That is exactly what I am doing. Are there any other options?

"Gord Dibben" wrote:

"told to copy" means you have used a linking formula such as =Sheet1!A1

Linking formulas do not bring over formatting............values only.


Gord Dibben MS Excel MVP

On Wed, 7 Apr 2010 13:55:01 -0700, Banker
wrote:

I have a cell on sheet 1 that I have added text to with some bolding,
coloring of text, etc. On Sheet 2 I have a cell that I have told to copy
whatever is in the cell on sheet 1 described above. Why doesn't the
formatting copy over too??

.