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
|