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"

"Dave Peterson" wrote:

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

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

Laurie21 wrote:

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


--

Dave Peterson