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