traffic light based on 3 different conditions
 

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

traffic light based on 3 different conditions
 

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


On 14 Sty, 13:55, wrote:
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

traffic light based on 3 different conditions
 

On 14 jan, 14:00, Jarek Kujawa wrote:
in Conditional Formatting click Add to add new conditions if the RED
is set
formula for Orange: =AND(A1<B1,A1C1)
then click Add again
formula for Green: =AND(A1B1,A1<C1)
OK

On 14 Sty, 13:55, wrote:



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- Tekst uit oorspronkelijk bericht niet weergeven -

- 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?

traffic light based on 3 different conditions
 

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

On 14 Sty, 14:36, wrote:
On 14 jan, 14:00, Jarek Kujawa wrote:





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

On 14 Sty, 13:55, wrote:

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- Tekst uit oorspronkelijk bericht niet weergeven -

- 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?- Ukryj cytowany tekst -

- Poka¿ cytowany tekst -

traffic light based on 3 different conditions
 

On 15 jan, 08:31, Jarek Kujawa wrote:
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

On 14 Sty, 14:36, wrote:



On 14 jan, 14:00, Jarek Kujawa wrote:

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

On 14 Sty, 13:55, wrote:

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- Tekst uit oorspronkelijk bericht niet weergeven -

- 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?- Ukryj cytowany tekst -

- Poka¿ cytowany tekst -- Tekst uit oorspronkelijk bericht niet weergeven -

- 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.

traffic light based on 3 different conditions
 

On 15 jan, 10:03, wrote:
On 15 jan, 08:31, Jarek Kujawa wrote:





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

On 14 Sty, 14:36, wrote:

On 14 jan, 14:00, Jarek Kujawa wrote:

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

On 14 Sty, 13:55, wrote:

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- Tekst uit oorspronkelijk bericht niet weergeven -

- 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?- Ukryj cytowany tekst -

- Poka¿ cytowany tekst -- Tekst uit oorspronkelijk bericht niet weergeven -

- 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.- Tekst uit oorspronkelijk bericht niet weergeven -

- Tekst uit oorspronkelijk bericht weergeven -

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

traffic light based on 3 different conditions
 

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

wrote in message
...

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

On 15 jan, 10:03, wrote:
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