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

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


<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>