How to Apply Conditional Formatting to Pivot Tables




About this tutorial:

Video duration: 00:08:39
In this video I explain how to apply conditional formatting to pivot tables. This helps make our pivot tables easier to read, and also gives them that “wow” factor.
⬇Download the example Excel file:

The process for applying conditional formatting to pivot tables is a bit different from regular ranges. Pivot tables give us a Formatting Options menu where we can specify the fields that we want to apply the format to.

I explain how to view the Formatting Options after the menu button disappears on the…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

31 thoughts on “How to Apply Conditional Formatting to Pivot Tables

    Sheetal Barapatre

    (June 28, 2020 - 8:16 pm)

    Hi Jon, Thank you. I am not able to see the formatting options button besides the cell. Can you please help. The version of excel I am using is Microsoft Excel for Mac Version 16.37. Waiting for your reply.

    Abstract Life

    (June 28, 2020 - 8:16 pm)

    Is there a way to highlight entire rows based on condition?

    Adnan Mirza

    (June 28, 2020 - 8:16 pm)

    Thanks a lot. This helped just at the right time.

    Rafał Czapiewski

    (June 28, 2020 - 8:16 pm)

    Well done, may God bless you, and your family.

    bijoudeaux1

    (June 28, 2020 - 8:16 pm)

    I've tried to download at least 3 files from your website in the past 2 hours or so and I get the message "Error establishing a database connection"

    boludoescoces

    (June 28, 2020 - 8:16 pm)

    Yessss!! Thanks 🙂

    Tanner Tucker

    (June 28, 2020 - 8:16 pm)

    Thank you. How does one identify the name of a table in the applies to area when conditionally formatting? Thank you.

    Punch Buddies

    (June 28, 2020 - 8:16 pm)

    Hello Jon, quick question – Do you have a Udemy course? Many thanks.

    You Can

    (June 28, 2020 - 8:16 pm)

    Nice one
    #youcanRA

    Chris Lamb

    (June 28, 2020 - 8:16 pm)

    Thank you! I was attempting this on a mac with excel version 16.25 and had no luck. I moved and edited my file on a PC as was able to make all the conditional formatting I needed, per your instructions, and then moved the file back to a mac – Worked Great!

    Kashif Raza

    (June 28, 2020 - 8:16 pm)

    How to add conditional formatting in Pivot Table with date column. I am facing problem in it so kindly guide me.
    Thanks

    Ka Ma

    (June 28, 2020 - 8:16 pm)

    Great!

    Irviantanto Hadiprasetyo

    (June 28, 2020 - 8:16 pm)

    Thank you John. It's helpfully for us.

    nikmat23

    (June 28, 2020 - 8:16 pm)

    Thanks a lot for the video, Jon. I have a question. In the part of video, where you show how to deal with multiple fields, if I want the top three products by column (i.e. by quarter), is it possible to do that? I need top three products for each quarter (q1, q2.. so on). Thanks

    Brian Parrott

    (June 28, 2020 - 8:16 pm)

    Thanks for the video. I'm somewhere between intermediate and advanced in excel knowledge. I was hoping for some feedback in a further in depth question. Currently, I don't believe it can be done and would like to know if I'm doing something incorrect.
    I'm measuring "clean" several areas throughout a house and the percent "clean" is shown through different columns (ranging .00 to 1) prior to the pivot.
    I have all of the clean results as Average of Clean Total, Average of Clean Exterior, Average of Clean Entrance etc in the Values
    I then dragged the values to Rows.
    I have a slicer ranging with different periods.
    Help requested: I am wanting to cond. format to show the bottom 1 item (pressure point) with the lowest percentage each period.
    Issue: Once I switch periods the formatting is no longer there.
    I believe that is due to being separate values. Is the request possible?
    Thanks in advance!

    Wayne Edmondson

    (June 28, 2020 - 8:16 pm)

    Hi Jon.. thanks for the video.. very insightful and helpful, as always. Thumbs up!

    Hej Hazel

    (June 28, 2020 - 8:16 pm)

    thank you soooo much~ be prepared for my first job via your videos~ really appreciate

    John Borg

    (June 28, 2020 - 8:16 pm)

    Thanks Jon very Helpful 🙂 🙂

    Pedro Cabral da Camara

    (June 28, 2020 - 8:16 pm)

    awesome!!

    Sardar Shafqat

    (June 28, 2020 - 8:16 pm)

    Very good job

    Heet Shah

    (June 28, 2020 - 8:16 pm)

    How to highlight the column and row individually and together without formula?

    Heet Shah

    (June 28, 2020 - 8:16 pm)

    One more I want to clear that there is 2 option 1) is all cell showing revenue value it means if I select top 3 option it shows top 3 among the total and 2) is is all cell showing value it means for product and qtr it means in product vise which one is highest.am I right?
    I am not getting the concept "qtr"

    Heet Shah

    (June 28, 2020 - 8:16 pm)

    I am not getting the "qtr" which you explained can you explain one more time?

    nboisen

    (June 28, 2020 - 8:16 pm)

    Excellent! Really helpful. It's so simple once you know the technique. I've been struggling with applying conditional formatting to pivot tables because I was selecting a range on cells before applying and the formatting would either disappear on get messed in whenever I refreshed the table. I figured there had to be a better way and now, thanks to your video, I know what it is. Thanks again.

    Learn With Dr Abdelrahman

    (June 28, 2020 - 8:16 pm)

    The Awesome Man and My teacher as usual ..Sending you love from the other world Egypt (Dr Abdelrahaman )

    Myanan Darkaung

    (June 28, 2020 - 8:16 pm)

    Thank you sir.

    Amir Rana Shahzad

    (June 28, 2020 - 8:16 pm)

    Good work

    Amir Rana Shahzad

    (June 28, 2020 - 8:16 pm)

    Is it possible in pivot to arrange product / items as alphabetically order
    Or as we want
    Order

    Philip Nelson

    (June 28, 2020 - 8:16 pm)

    Excellent John – clear and helpful as always

    Bikas Singh

    (June 28, 2020 - 8:16 pm)

    Cool

    Sandeep Kothari

    (June 28, 2020 - 8:16 pm)

    Wow!

Leave a Reply

Your email address will not be published. Required fields are marked *