Hi

check out conditional formatting - Debra Dalgleish has some good notes on
her website.

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

Cheers
julieD

"Parker1333" wrote in message
...