Pinterest Pixel

Pivot Table Conditional Formatting

  Want to know How to Conditionally Format Blank Cells in Excel Pivot Tables? *** Watch our... read more

Download Excel Workbook
John Michaloudis
Posted on



Want to know How to Conditionally Format Blank Cells in Excel Pivot Tables?

*** Watch our video and step by step guide below with free downloadable Excel workbook to practice ***

Watch on YouTube and give it a thumbs up 👍

Pivot Table Conditional Formatting | MyExcelOnline

Inserting a Pivot Table is very easy to do in Microsoft Excel: Inserting a Pivot Table

Adding some Conditional Formats to the Pivot Table allows a user to highlight key data in a split second.

See how easy it is to add some color to your analysis.

download workbookCond-Format-a-Pivot-Table.xlsx

STEP 1: We want to create a rule that will highlight values greater than 100,000

Select any cell inside the Pivot Table

Pivot Table Conditional Formatting

STEP 2: Go to Home > Conditional Formatting > New Rule

Pivot Table Conditional Formatting

STEP 3: Select the following settings. We are selecting the third option so that the formatting rules only apply to the individual cell values

Click Format

Pivot Table Conditional Formatting

STEP 4: Select Fill and pick a color of your choice

Click OK twice

Pivot Table Conditional Formatting

The formatting rule is now applied to your entire Pivot Table!

Pivot Table Conditional Formatting

Helpful Resource:


If you like this Excel tip, please share itEmail this to someone


Pin on Pinterest


Share on Facebook


Tweet about this on Twitter


Share on LinkedIn


Founder & Chief Inspirational Officer at

John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship Academy Online Course.

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!