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