Cell Format

E

Execeld

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)
 
B

Bondi

Execeld said:
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)
Click to expand...

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
 
R

Roger Govier

Hi

You would need to set the default format of the cell to Green.
Then, Format>Conditional Formatting>Cell Value is>dropdown to select
Less than> enter 0 in white pane
Click Format and set Font to Red
 
Top