If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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~ |
Thread Tools | |
Display Modes | |
|
|