conditional formatting

[joe@malvern]

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

 

[Bob Umlas, Excel MVP]

First select A1:T400, then use CF of =$A1
Bob Umlas
Excel MVP

 

[joe@malvern]

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

 

[Gord Dibben]

Select A1:T400

=$A1="dead"

Locks the reference to A column only as the trigger for each row.


Gord Dibben MS Excel MVP