Changing Background Color as a True/False Response
 

I would like to change the background color of a cell in response to a FALSE
condition in an IF statement in Excel2003.

Consider a cell A1 containing the number 5. I would like to use an IF
statement in cell A2 to either display the number in A1 if it is greater than
6 or change the cell background color red if it is less the or equal to 6. I
would use the equation in A2: =IF(A16, ???, A1).

What can be entered in place of the ??? to provide a red background as a
FALSE result in cell A2?

Changing Background Color as a True/False Response
 

Use formatconditional formatting, then cell value is less than or equal to
6
click the format button to select the font and then click OK twice

--
Regards,

Peo Sjoblom


"ajurczak" wrote in message
...
I would like to change the background color of a cell in response to a
FALSE
condition in an IF statement in Excel2003.

Consider a cell A1 containing the number 5. I would like to use an IF
statement in cell A2 to either display the number in A1 if it is greater
than
6 or change the cell background color red if it is less the or equal to 6.
I
would use the equation in A2: =IF(A16, ???, A1).

What can be entered in place of the ??? to provide a red background as a
FALSE result in cell A2?