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
...

i'm guessing conditional formatting is what you're after (format /
conditional formatting) - if you'ld like to post back with full details in
the message body (not the subject line) we might be able to provide further
assistance

regards
JulieD

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