FORMATTING CELLS

[steven.gunderson]

I want to just do a formula to have one sheet in a workbook = another. When I just use "=" sign, though, everything comes over in the default text size and font. Is there a way to do this and retain the original font sizes and boldness?
Steve

 

[Bob Flanagan]

Did you try Edit, paste special to paste the formats?

Robert Flanagan
Add-ins.com LLC
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

 

[steven.gunderson]

I want to just do a formula to have one sheet in a workbook = another. When I just use "=" sign, though, everything comes over in the default text size and font. Is there a way to do this and retain the original font sizes and boldness?
Steve

Yeah, Tried that. It didn't work. It didn;t default to the worksheets font, but it did make everything the same font and boldness of whatever was in the first cell that I copied. Still need some help on this.

 

[Gord Dibben]

Formulas can return values only...............they cannot return
formats.

You could use Conditional Formatting on source cells to achieve the
formatting then use that same CF on the target cells.


Gord


On Tue, 12 Jun 2012 11:05:55 -0700 (PDT),