You can do this with Conditional Formatting. Other than that, I think
you'll need a macro.

Regards

Trevor


"thediamondfam" wrote in message
...
I am trying to change the text color of multiple cells based on the value
of
one cell