But you can CF A1 on Sheet1 to red if value is 23

And you can CF A1 on sheet2 to red if value is 23

Select both sheets and enter your CF for A1


Gord


On Mon, 9 Mar 2009 11:48:01 -0700, L. Davis
wrote:

I don't believe you can use Conditional formating on different worksheets.

"Gord Dibben" wrote:

You don't by using a link only.

Maybe format both cells with identical Conditional Formatting?



Gord Dibben MS Excel MVP


On Mon, 9 Mar 2009 10:35:01 -0700, L. Davis <L.
wrote:

I understand how to link a cell to another cell in a different worksheet.
How do I link the formatting of that link cell as well?