Start by experimenting with Format|Conditional Formatting
Then come back if more help is needed
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Lee" wrote in message
...
Does anyone know of a way to check for a value in two different cells, and
if
a certain combination of values exists, change the format of another cell?

Any help would be much appreciated.

Thank You.