Hi

okay, click on cell A2, choose format / conditional formatting ...
choose
formula is
type
=AND($A2=$A1,$A2<"")
click on FORMAT, choose Patterns, choose ORANGE
click on ADD
choose
formula is
type
=AND($A2<$A1,$A2<"")
click on FORMAT, choose Patterns, choose RED
click on ADD
choose
formula is
type
=$A2$A1
click on FORMAT, choose Patterns, choose GREEN
click OK

now, click on A2, click on the format painter (big yellow paintbrush,
standard toolbar), click on A3 and drag as far as you want.

Hope this helps
Cheers
JulieD

"PCOR" wrote in message
...

I have a col on numbers in Col A
I want the background of A2 to be GREEN, if the value of A1 is LESS than
A2 , ORANGE is the value of A2 is EQUAL to A1 or RED if the Value of A1 is
MORE that A2
How can I do this for every line(I have about 30 lines in col A)
Thanks

--
Norton Professional 2004 says this email is clean...believe it