| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Conditional Formatting - Not all colors work?
I am using the below to auto change color if it meets the condition...
=IF(F26=0,IF(OR((F26)<=2,(F26)=-1),"GREEN", IF(AND((F26)<=2.5,(F26)<=-1.5),"AMBER","RED")), IF(AND((F26)=2,(F26)<=-1),"GREEN", IF(AND((F26)=2.5,(F26)=-1.5),"AMBER","RED"))) Any help is appreciated. -- J~ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting - more than 4 cell colors | Excel Worksheet Functions | |||
| Conditional Formatting Colors have disappear on my laptop. | Excel Worksheet Functions | |||
| Conditional Formatting with Colours / Colors | Excel Worksheet Functions | |||
| Conditional Formatting in 6 colors | Excel Discussion (Misc queries) | |||
| Conditional Formatting Question - Different Cell Colors?? | Excel Discussion (Misc queries) | |||
Threaded Mode
