Look up conditional formatting in help


cell value greater than 0

format button and green font


add a condition and use


cell value less than 0

format button and red font

--


Regards,


Peo Sjoblom

" wrote
in message ...
If I have a group of equations with answers that are both positive and
negative is there a way to have the equations that provide a negative
number
automatically show up in red lettering and positive show up in green
letters.