conditional format?

[PCOR]

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

 

[JulieD]

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

 

[Frank Kabel]

Hi
- select A2:A30
- goto 'Format - Conditional format'
- enter the following formula
=A1<A2
- choose your green format (This assumes that you want to compare for
the next row A3 with A2. If you always want to compare the row with A1
change the formula to
=A$1<A2

The other two conditions have the formulas
=A1=A2 (For yellow)
and
=A1>A2 (for red)

 

[PCOR]

Does work great Many thnaks
Ian M