Where conditional formatting is concerned, this is often the case. In this Excel tutorial, I’ll show you how to apply conditional formatting to a filtered PivotTable in Excel.

These files demonstrate the technique described in the article Office Q&A: After-the-fact captions and easy counts using a PivotTable.