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

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