conditional formatting

  • Thread starter Thread starter joe@malvern
  • Start date Start date
J

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
 
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
 
Select A1:T400

=$A1="dead"

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


Gord Dibben MS Excel MVP
 
Back
Top