Conditional formatting.

See http://www.contextures.com/xlCondFormat01.html

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Nick" wrote in message
...
Is it possible to change the background color of a cell or text color if a
certain criteria is met?