| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Linear Mode
