Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Format 2007
I have 2 columns of numbers. If the number in column 2 is adjacent number
in row 1, then red: if < black, if = then blue. I know how to do this for each individual row by using the CF, but how can I avoid writing this over and over again for each row? I thin I need to use a formula, but cannot figure it out. Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Format 2007
Turn the absolute references to relative references for the rows in your CF
formula. (Delete the $ sign preceding the row reference, so change A$2 to A2.) -- David Biddulph "Paula" wrote in message ... I have 2 columns of numbers. If the number in column 2 is adjacent number in row 1, then red: if < black, if = then blue. I know how to do this for each individual row by using the CF, but how can I avoid writing this over and over again for each row? I thin I need to use a formula, but cannot figure it out. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Format Excel 2007 | Excel Discussion (Misc queries) | |||
How to conditional format in 3 colors in 2007 | Excel Discussion (Misc queries) | |||
conditional format error Excel 2007 | Excel Worksheet Functions | |||
Conditional Format - Excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 Conditional Format with Formula | Excel Discussion (Misc queries) |