Pinterest Pixel

Pivot Table Conditional Formatting

John Michaloudis
Pivot Table Conditional Formatting.
Inserting a Pivot Table is very easy to do in Microsoft Excel: Inserting a Pivot Table
Pivot Table Conditional Formatting | MyExcelOnline Pivot Table Conditional Formatting | MyExcelOnline

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

If you like this Excel tip, please share it
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 MyExcelOnline Academy Online Course.

See also  Distribute and Align Shapes in Excel

Star 30 Days - Full Access Star

One Dollar Trial

$1 Trial for 30 days!

Access for $1

Cancel Anytime

One Dollar Trial
  • Get FULL ACCESS to all our Excel & Office courses, bonuses, and support for just USD $1 today! Enjoy 30 days of learning and expert help.
  • You can CANCEL ANYTIME — no strings attached! Even if it’s on day 29, you won’t be charged again.
  • You'll get to keep all our downloadable Excel E-Books, Workbooks, Templates, and Cheat Sheets - yours to enjoy FOREVER!
  • Practice Workbooks
  • Certificates of Completion
  • 5 Amazing Bonuses
Satisfaction Guaranteed
Accepted paymend methods
Secure checkout

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!

Share to...