+ Reply to Thread
Results 1 to 4 of 4

conditional formatting in pivot table

  1. #1
    Registered User
    Join Date
    12-15-2020
    Location
    Colorado Springs, CO
    MS-Off Ver
    365
    Posts
    15

    conditional formatting in pivot table

    I have rows of data that look like this example in my pivot table:
    Please Login or Register  to view this content.
    I want a conditional format rule that highlights each month where the amount is different than the prior month. For this example, I would expect Jun, Aug, and Sep to be highlighted. Can I accomplish this in a pivot table and if so how exactly?
    Last edited by 6StringJazzer; 11-03-2021 at 03:43 PM. Reason: code tags for data formatting

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,548

    Re: conditional formatting in pivot table

    The following works for the sample of data provided.
    The following formula in applied to All cells showing "sum of value" values for "ref" and "date": =AND(E6<>F6,LEFT(E$5,1)+0=1)
    For future reference, you will usually get faster results if you attach an Excel file (instructions are given in the "HOW TO ATTACH YOUR SAMPLE WORKBOOK" banner at the top of the page).
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Registered User
    Join Date
    12-15-2020
    Location
    Colorado Springs, CO
    MS-Off Ver
    365
    Posts
    15

    Re: conditional formatting in pivot table

    Wow, that is fantastic. Thank you so much

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,548

    Re: conditional formatting in pivot table

    You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 10-05-2021, 10:33 AM
  2. [SOLVED] Pivot table conditional formatting
    By ChipsSlave in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-24-2017, 04:22 AM
  3. Replies: 1
    Last Post: 12-08-2016, 03:14 PM
  4. pivot table and conditional conditional formatting
    By Veronsito in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-07-2016, 12:15 PM
  5. Replies: 9
    Last Post: 03-07-2016, 10:39 AM
  6. Replies: 2
    Last Post: 09-04-2015, 02:47 AM
  7. Conditional formatting in a pivot table
    By pdalal in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-17-2015, 08:57 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1