The colour represents of a cell represents the status of the project on which
I am working, it is therefore subject to change. When I change the colour in
a cell sheet 1 it does not alter the colour of the corresponding cell (=) in
sheet two. Is there a way to solve this problem?
"Dave Peterson" wrote:
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
|