If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
conditional formatting
I have a conditional format which the formula indicates true for column "A"
and column "B" background shades red. how do I set up so columns "A-T" highlight red and set-up so all rows 1-400 are formatted when column "A" is true? I have tried and cannot get it to work...thanks Joe |
#2
|
|||
|
|||
conditional formatting
First select A1:T400, then use CF of =$A1
Bob Umlas Excel MVP "joe@malvern" wrote: I have a conditional format which the formula indicates true for column "A" and column "B" background shades red. how do I set up so columns "A-T" highlight red and set-up so all rows 1-400 are formatted when column "A" is true? I have tried and cannot get it to work...thanks Joe |
#3
|
|||
|
|||
conditional formatting
I cannot get it to work...some further info- and appreciate your help
it is a sales pipeline and when =A1="dead" cell B1 is conditionally formatted to shade red. works fine and I have this CD for B1:B400. when I highlight A1:T400 and try to conditionally format I get A1:T:400 shaded in red when A1="dead"? A1:A400 is a data validated drop down menu with "dead" or "sold". How do I set up so that the row (or columns A:T for each row) highlight when Column "A" ="dead"? thanks again "Bob Umlas, Excel MVP" wrote: First select A1:T400, then use CF of =$A1 Bob Umlas Excel MVP "joe@malvern" wrote: I have a conditional format which the formula indicates true for column "A" and column "B" background shades red. how do I set up so columns "A-T" highlight red and set-up so all rows 1-400 are formatted when column "A" is true? I have tried and cannot get it to work...thanks Joe |
#4
|
|||
|
|||
conditional formatting
Select A1:T400
=$A1="dead" Locks the reference to A column only as the trigger for each row. Gord Dibben MS Excel MVP On Wed, 18 Nov 2009 09:54:07 -0800, joe@malvern wrote: I cannot get it to work...some further info- and appreciate your help it is a sales pipeline and when =A1="dead" cell B1 is conditionally formatted to shade red. works fine and I have this CD for B1:B400. when I highlight A1:T400 and try to conditionally format I get A1:T:400 shaded in red when A1="dead"? A1:A400 is a data validated drop down menu with "dead" or "sold". How do I set up so that the row (or columns A:T for each row) highlight when Column "A" ="dead"? thanks again "Bob Umlas, Excel MVP" wrote: First select A1:T400, then use CF of =$A1 Bob Umlas Excel MVP "joe@malvern" wrote: I have a conditional format which the formula indicates true for column "A" and column "B" background shades red. how do I set up so columns "A-T" highlight red and set-up so all rows 1-400 are formatted when column "A" is true? I have tried and cannot get it to work...thanks Joe |
Thread Tools | |
Display Modes | |
|
|