cell pattern depening on cell content

S

stevendeferme

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)
 
J

John Bundy

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
 
Top