View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
PCOR PCOR is offline
external usenet poster
 
Posts: 77
Default 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