| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formatting cells Auto fill color using €œIf€
I have the following formula in a cell:
=IF(Q28<0.65,"BLACK",IF(Q28<0.85,"RED",IF(Q28<1,"Y ELLOW","GREEN"))) I am attempting to change the color of Green to Bright Green. I assumed changing the formula to: =IF(Q28<0.65,"BLACK",IF(Q28<0.85,"RED",IF(Q28<1,"Y ELLOW","BRIGHTGREEN"))) would work but in changing the formula resulted in a Black filled cell not bright green. If some one could advise how to change to a different color it would be appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
| Identifying the Active Fill Color | Excel Discussion (Misc queries) | |||
| Auto Fill Options | Excel Discussion (Misc queries) | |||
| background formatting across multiple cells | Excel Discussion (Misc queries) | |||
| Cells losing formatting | Excel Discussion (Misc queries) | |||
Threaded Mode
