Conditional Formatting referencing other Worksheets

[mcarnold]

Hello,

I sometimes get lost with too much formula-ese, so please forgive me if
the answer is clearly out there.

First, let me state that I understand that when a cell is linked, just
the value, not the format travels with it.

Here is what I want to do. I have a "dashboard" worksheet that combines
the tasks off of 5 other worksheets. Basically I want to set up
formatting so if the cell references:
'wksht1'=blue
'wksht2'=pink
'wksht3'=yellow

....and so on...

What is the simplest way to do this? From my research on the boards it
looks like conditional formatting is consistently recommended, however,
if someone could guide me through how that would work it would be much
appreciated. Thanks a billion!

Meghan

 

[Trevor Shuttleworth]

Not sure what you get with Excel 2007 but in earlier versions you are
limited to 3 conditions. Even so, I don't think you can check the text of
the formula, as opposed to the value that the formula returns. As you must
know what formula you are putting in the cell, can't you just colour it
yourself ?

Regards

Trevor