Copy and paste???

Formulas return values--not formats.

Laurie21 wrote:

If I put = in a cell in sheet 1 and then click on a cell in sheet 2 and press
'enter' it transfers only the text in the sheet 2 cell not the colour of the
cell. Is there anyway that I can get it to transfer the cell colour as well?

--

Dave Peterson