Thanks so much for the quick response. The idea didn't even cross my
mind.

Clay
Tom Ogilvy wrote:
You can do that with conditional formatting as well. You can change Cell
Value is to formula is and put in a formulat that refers to the other cell.

--
Regards,
Tom Ogilvy


"crs" wrote:

I realize that in some cases you can use conditional formatting to
change the color of the cell contents according to cell value, but I
need to change the color of one cell's contents according to the value
of a different cell. For instance....if B1 = x, then C1 is red but if
B1 = y, then C1 is blue..........any suggestions.
Clay