Look up conditional formatting in Help.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Phxlatinoboi®" wrote in message
...
I am using the following formula:

=IF(I9<0,(H9-I9)/I9,IF(H9<0,(G9-H9)/H9,IF(G9<0,(F9-G9)/G9,0)))

How can I get the results to show if negative to turn "red" and if
positive
to be "black"?