Look at Conditional Formatting. Details in Excel help.
[And next time, please ask the question in the body of the message, not in
the subject line.]
[And please stop SHOUTING. Get your caps lock key repaired.]
--
David Biddulph

"V" wrote in message
...