You don’t need a complex expression to add conditional formatting to a filtered PivotTable in Microsoft Excel.

It’s doubtful that Excel will automatically sense and update a pivot table if you add new cells outside of the current table’s range. That’s a weakness that Sheets has, too.

Table Style Options in Excel. Microsoft Excel tables are a way to organize complex data into rows and columns, making your information easy to understand.

Microsoft has announced a beta version of Excel that allows pivot tables to automatically update themselves when data is changed.