Go to Format-Conditional formatting. Set it how you want such as "Cell value
is" then "Less Than" and finally 0. Click the format button and select what
you want the cell to look like when it is less than zero. Click Add to add a
rule for =0 or above 0
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"stevendeferme" wrote:

hello,

I want to accomplish the following:
When the cell content is a negative number, i want the cellcolor to be red,
when the cell content is a positive number, i wnat the cell collo to be green.

But If this isn't possible, then maybe the following:
a positive numùber is displayed in green,
a negative number is displayed in red (this is possible through cell format
options)