Using = sign will link data between sheets but not colour. Why?

[Guest]

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]

Copy and paste???

Formulas return values--not formats.

 

[Guest]

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]

Copy and paste--even via a macro would work.

Any chance you could use format|conditional formatting for both cells--with the
same rules?

 

[Guest]

What is a macro? - sorry I am a computer novice. When i tried conditional
formating it said that "you may not use references to other worksheets or
workbooks for Conditional Formatting criteria"

 

[Vasant Nanavati]

Simply, you can't link color changes. If you are manually changing the color
of the first cell based on your project status, there is no way to
automatically change the color of the second (linked) cell to the same
color.

You could do it using a macro, but it would be just as simple to change the
color of the second cell manually.

--

Vasant

What is a macro? - sorry I am a computer novice. When i tried conditional
formating it said that "you may not use references to other worksheets or
workbooks for Conditional Formatting criteria"