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

Power Query technology in Excel allows you to unpivot static tables & access your tables, perform a transformation & create a PivotTable from the transformed data.