How to Apply Conditional Formatting to a Pivot Table in Excel

A Pivot Table is a great way for you to summarize and present the information contained in your data set. When you apply conditional formatting to your Pivot Table, you can “visually” spot important trends or anomolies in your data.

Improvements to Conditional Formatting

Conditional Formatting in Pivot Table

Condition Formatting for Above Average

Beginning with Excel 2007, Conditional Formatting has been dramatically improved. In addtion to pre-built formula rules, you can also apply Data Visualizations (Icon Sets, Data Bars and Color Scales).

Conditional Formatting for Above Average

In this lesson, I apply the pre-built “Above Average” rule. I want Excel to dynamically format the summary values that answer, “TRUE” to this question: “Is this value “Above the Average” in the range of cells selected?

This is the key to understanding how Conditional Formatting works. Special Formatting is applied only when the answer to your CONDITION (a rule or a formula) is TRUE.

Dynamically Filter Conditional Formatting

In this lesson, I use the Report Filter zone in my Pivot Table to see how conditions change when I change the time period in my report. Values that meet the Condition, “Above the Average,” receive the formatting that I established in my rule. Try this on your Pivot Table. It is a wonderful tool to use in an Excel Dashboard.

View This Video Tutorial in High Definition

Follow this link to watch this lesson in High Definition on my YouTube Channel, DannyRocksExcels.

My Extended Length Pivot Table Video Tutorials

I offer “free of charge,” a 24 minute in-depth video tutorial for creating your first Pivot Table in Excel. Follow this link to learn how to view it online or to download it to your computer.

Vist My New Online Shopping Site

My new, secure online shopping website – – is now open. I invite you to visit and learn more about the new products that I have added.

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn


  1. Lance Kunde says:

    What is an ARF file?

  2. Hi Lance –

    An ARF File is a Video Format used by WebEx, for example, to watch videos online.

    Notice, that on my site that you can also choose to download my videos to watch on your computer.

    Let me know if you have any difficulty accessing or viewing my materials.

    Danny Rocks
    The Company Rocks

  3. David Bandel says:

    Video tutorials are annoying.

    I (and most people) read far faster than people talk. Also you can’t “ctrl-f search” for certain text in a video. You don’t have all the information viewable at once at a glance. You have to arbitrarily click through the video then listen and watch for a bit to see if it’s gotten to what is relevant to you.

    Video tutorials are by far the less efficient and less logical means for conveying information and teaching.

    Danny. Your videos and any advice you think you have to give will be ignored.

  4. David – Thank you for your opinion.



  1. brendan mccormack…

    […]How to Apply Conditional Formatting to an Excel Pivot Table | Danny Rocks Tips and Timesavers[…]…

Speak Your Mind