Conditional Formatting in Excel List/Table

  • Thread starter Thread starter DzednConfsd
  • Start date Start date
D

DzednConfsd

I have an Excel List in Excel 2003 or its called an Excel Table in
Excel 2007. Data validation rules and formulas automatically expand
into new rows as they are added to the list or table. BUT I can't get
my conditional formatting rules to automatically expand. Am I doing
something wrong or is this something I have to live with? THANKS
 
Hi,

I think it will work if you select the whole range inside the List including
the blank row on the last line.
 
Back
Top