traffic light based on 3 different conditions

  • Thread starter Thread starter proo
  • Start date Start date
P

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
 
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
 
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 -
Click to expand...

That part works.
Unfortunately the formula does not work. Do you maybe know if there is
an error in the formula?
 
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
 
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 -
Click to expand...

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.
 
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 -
Click to expand...

Changing the , to a ; made the difference.
Now it works.
 
Yes, you always need to know what your Windows regional settings have
specified as a list separator.
 
Back
Top