| 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~ |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Conditional Formatting - Not all colors work?
In 2003, when you set up a conditional format, you can choose one color for
the condition. If you want to do something like what you are showing, you're going to need to use a Worksheet_Change event and code something like this: http://www.developersdex.com/vb/mess...2677&r=5771007 -- HTH, Barb Reinhardt "PSS" wrote: 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~ |
| Reply |
| 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) | |||
Linear Mode
