How to conditional formatting pivot table in Excel?

Conditional Formatting feature is helpful in our Excel working, and PivotTable also do a favor for our data analysis, but how to conditional formatting a pivot table data in Excel?

Conditional formatting pivot table

Conditional formatting pivot table

1. Select the data range you want to conditional formatting, then click Home > Conditional Formatting.

Note: You only can conditional formatting the Field in Values section in the PivotTable Field List Pane.

2. Then in the popped out list, select the conditional formatting rule you need, here I select Data Bars for instance. See screenshot:

3. Select the fill color you like, and then the selected cell range has been formatted. And a Formatting Options button appears beside the formatted cell range. See screenshot:

4. Click at this Formatting Options button, there are some options for you to select. You can check the option as you need.

Check All cells showing “Sum of Value” values option, the result shown as below:

Check All cells showing “Sum of Value” values for “Month” option, the result shown as below:

Tip: You also can go to New Formatting Rule dialog to select the Apply Rule To option and formatting rule type, then click Format to go to the Format Cells dialog to specify the formatting you need.

Relative Articles:

• Highlight largest / lowest value in each row or column
• Highlight above/below average
• Highlight dates older than 30 days