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.