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~
0
PSS (1)
4/18/2008 2:35:01 PM
excel.newusers 15348 articles. 2 followers. Follow

1 Replies
281 Views

Similar Articles

[PageSpeed] 9

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

-- 
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~
0
4/18/2008 10:49:00 PM
Reply:

Similar Artilces: