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