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~

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~