View Single Post
  #2  
Old November 18th, 2009, 04:21 PM posted to microsoft.public.excel.misc
Bob Umlas, Excel MVP
external usenet poster
 
Posts: 275
Default 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