Pivot tables generate great reports in Microsoft Excel, but adding a filter or two can make them even more flexible. Here's how.

Conditional formatting setup We’ll apply a conditional format and a filter to a single column of values. Then, we’ll add a function that updates as you filter the data by the conditional format.