Conditional formatting doesn't expand when table does.

[jsimon1212]

I use a table with several conditional formatting rules, created in Excel 2010. When I tab or drag down to add lines at the bottom of the table, the conditional formatting extends to those new rows. When my coworker, who uses 2007, adds rows, the conditional formatting is not copied to the new rows. I always have to open his files and edit all the conditional formatting rules to include the newly added rows.

Is there a way to make it so his conditional formatting extends when adding rows? Thanks.

[jeffreybrown]

I'm using 2007 and it works the same way.

Created a range
Selected Ctrl + T to convert into a table
Applied a condition
Tabbed down for a new row and the condition followed