Hi

You would need to set the default format of the cell to Green.
Then, FormatConditional FormattingCell Value isdropdown to select
Less than enter 0 in white pane
Click Format and set Font to Red
--
Regards

Roger Govier


"Execeld" wrote in message
...
Could any one help me in getting to change the format of the cell
depending
on an if statement. I would like to get the cell to change colour if
the
formula result is below 0
IF(A 1<0,then change call format to red ,Cell format green)