Conditional formatting tables
Conditional formatting in tables, at the moment, attempting to apply conditional formatting to a table causes the document to become incredibly unstable especially as the database size grows. It's also incredibly unwieldy.
Conditional formatting in general should probably be updated to be more dynamic and consistent with other aspects of Excel, it doesn't appear that conditional formatting has changed much since much earlier versions of Excel.
PivotTables also automatically break conditional formatting of entire rows or columns of data. It would be nice to be able to apply conditional formatting dynamically to rows of data in PivotTables.
i want to change format using conditional formtting
Gretchen, the rule itself cannot take a table reference. It automatically converts that reference into a range and then that range fragments, even though the table uses that conditional formatting as the default column format and applies it to your new row. The end result is a lot of fragmented rules.
You guys should go join the party at the other conditional formatting suggestion. Yours was just posted there. Every few months, there is a flurry of comments about how messed up it is that MS hasn't fixed this. Pretty entertaining. Your suggestion was just posted there, so you may be getting more up votes soon.
Gretchen Bren commented
Use table reference for columns (IE [@column]) so the entire column is covered by conditional format, including newly added rows at any location.