Change cell colour based on an IF statment
 

How can I make a cell change colour based on and IF statment.

I want one cell to go red if the value in another cell is negative.

Thank you.

Richard

Change cell colour based on an IF statment
 

You could use conditional formatting.

Seelct your cell then
Format|Conditional format
Select formula is and enter the formula
=$B$1<0

Select a colour
Ok

Mike

"VoxBox-Richard" wrote:

How can I make a cell change colour based on and IF statment.

I want one cell to go red if the value in another cell is negative.

Thank you.

Richard