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),
wrote:

On Thursday, June 7, 2012 9:56:33 AM UTC-6, (unknown) wrote:
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.