Formatting Font colour depending on value

[Rexy69]

Hi i'm sure this is really simple but i can't work it out
i was positive numbers with a (+) and to be coloured green and negative numbers with a (-) and be red but i was 0 to stay black

here is what i have so far for the formatting of the cells

: [Green]+£#,##0.00;[Red]-£#,##0.00

this works apart from £0.00 goes green also , is there something i can add to the above to make £0.00 stay black??

Thanks

Rexy~

 

[ISY]

Hi

Run the macro, cause translation problems I did not find the required colors

    Range("B1").Select
    Selection.NumberFormat = _
        "[Blue][>0]+£#,##0.00;[Red][<0]-£#,##0.00;£#,##0.00;@"
    Range("C1").Select
    Selection.NumberFormat = _
        "[Blue][>0]+£ * #,##0.00;[Red][<0]-£ * #,##0.00;£ * #,##0.00;@"

 

[Rexy69]

Thanks that worked , it also helped me workout how to do it in the cell format

if anyone wants to know its : (Color 10) is a darker green, the [green] is too bright.

[Color10]+£#,##0.00;[Red]-£#,##0.00;[Black]£#,##0.00

Thanks

Rexy~