No idea what you're trying to change color based on (it helps to put
your question in the body of the message), but you might look at
Conditional Formatting in XL Help.

In article ,
lisamariehewson wrote: