| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using CF to change colour in cell based on date? | Excel Discussion (Misc queries) | |||
| Macro to change cell colour based on words | Excel Programming | |||
| change current cell colour based on the value of adjacent cell on other worksheet | Excel Programming | |||
| How to change cell colour based on numer of months? | Excel Programming | |||
| Change the colour of a bunch of cells, based on one cell. | Excel Programming | |||
Linear Mode
