traffic light based on 3 different conditions

[proo]

Question;
I want conditional formatting on cel A1.
Red when A1 < B1 AND <C1
Orange when A1 < B1 AND >C1
Green when A1 >B1 AND >C1
I can make the 3 different colours but I cannot get the formula
working.
My formula (for RED):
=AND($A1<$B1,$A1<$C1)
Using MS Excel 2003

 

[Jarek Kujawa]

in Conditional Formatting click Add to add new conditions if the RED
is set
formula for Orange: =AND(A1<B1,A1>C1)
then click Add again
formula for Green: =AND(A1>B1,A1<C1)
OK

 

[proo]

in Conditional Formatting click Add to add new conditions if the RED
is set
formula for Orange: =AND(A1<B1,A1>C1)
then click Add again
formula for Green: =AND(A1>B1,A1<C1)
OK



- Tekst uit oorspronkelijk bericht weergeven -

That part works.
Unfortunately the formula does not work. Do you maybe know if there is
an error in the formula?

 

[Jarek Kujawa]

what do you mean by "Unfortunately the formula does not work"?
IMHO there shouldn't be a formula =AND($A1<$B1,$A1<$C1) in A1, just
another formula or value

 

[proo]

what do you mean by "Unfortunately the formula does not work"?
IMHO there shouldn't be a formula =AND($A1<$B1,$A1<$C1) in A1, just
another formula or value





- Tekst uit oorspronkelijk bericht weergeven -

This is my formula for GREEN.
=AND($A76>$D76,$A76>$G76)
I get an error report which highlights $D76,$A76
Which probably indicates there is an error in the comma.
In the cels A,D and G 76 are only values.

 

[proo]

This is my formula for GREEN.
=AND($A76>$D76,$A76>$G76)
I get an error report which highlights $D76,$A76
Which probably indicates there is an error in the comma.
In the cels A,D and G 76 are only values.- Tekst uit oorspronkelijk bericht niet weergeven -

- Tekst uit oorspronkelijk bericht weergeven -

Changing the , to a ; made the difference.
Now it works.

 

[David Biddulph]

Yes, you always need to know what your Windows regional settings have
specified as a list separator.