Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Capture conditional format as cell format | Excel Discussion (Misc queries) | |||
New Conditional Format Overriding Previous Conditional Format | Excel Discussion (Misc queries) | |||
Multiple conditional on conditional format formula | Excel Programming | |||
Multiple conditional on conditional format formula | Excel Programming | |||
Keep format after paste from other worksheets - conditional format or EnableControl solution doesn't work | Excel Programming |