Conditional Formatting in Excel List/Table

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
 
S

Shane Devenshire

Hi,

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting not holding in pivot table querying Access 2
Excel Conditional Formatting Removal 7
Bug: Array formulas in conditional formatting ignored on XMLSpreadsheet load 2
Generating a list of Conditional Formatting used in a workbook 3
CONDITIONAL FORMATTING BETWEEN SHEETS 1
Copy Conditional Formatting to Another Sheet 3
Conditional Formatting 1
[Excel 2011] Insert lines in table with formuals and formatting preserved 8

Top