conditional format?
 

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

conditional format?
 

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

conditional format?
 

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
=A1A2 (for red)


--
Regards
Frank Kabel
Frankfurt, Germany


PCOR wrote:
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

Thanks to both of you
 

Does work great Many thnaks
Ian M
"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