| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF hypotheticals that are not TRUE/FALSE response | Excel Worksheet Functions | |||
| changing cell background color | Excel Worksheet Functions | |||
| Changing the background color of my Word Screen | New Users to Excel | |||
| Want to change the color of a true/false logical statement with i. | Excel Worksheet Functions | |||
| How can I make a True or False statement a certain color when usi. | Excel Worksheet Functions | |||
Threaded Mode
