Conditional Formatting - Not all colors work?

[PSS]

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.

 

[Barb Reinhardt]

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/message.asp?p=2677&r=5771007