How can I set a row to have a different color if it has a +ve val.

[Bob Phillips]

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
(e-mail address removed)> wrote in message
news:[email protected]...

 

[JulieD]

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
(e-mail address removed)> wrote in message
news:[email protected]...