Dave,

Try:

1st condition Formula is: =ISBLANK(A1) ... no format set

2nd condition: Cell Value is: Greater than 0 (green)

3rd Condition: Cell value is: Less than 0 (red)

HTH

"DaveyJones" wrote:

Probably quite an easy one but i'm trying to get the cell to be green if it
is above 0, red if it is below and no colour if it is 0, however, the values
in the cells are part of a formula ie

If(A1="", "", B1-C2)

so if A1 is blank, the current cell will be blank. But for some reason the
condional format see's the formula as being greater than 0 and whatever I do,
it colours the cell green, any suggestions??
--
Dave