Use conditional formatting.

Check out 'Highlight cells that meet specific conditions' in* help.


--

HTH

RP
(remove nothere from the email address if mailing direct)


"set color to row with value with formula" <set color to row with value with
wrote in message
...