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