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