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)

Execeld wrote:
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)

Hi,
One way would be to use Conditional Formatting.

Goto Format - Conditional Formatting and chose Cell Value Less Than
....
Then Click Format - Patterns and chose Green..

Regards,
Bondi

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)