You don't need CF.
Custom Format:
[Green]General;[Red]-General;0;General
--
David Biddulph


"Nevyn" wrote in message
...
Hi Folks,
Need some advice please. I am wanting to format a column of cells so that
if
they are negative numbers the cell is red and if positive the are green. I
keep going rond in circles trying to work it out. I can get one half but
no
the other.


Advice and help appreciated.
Nevyn.