Results 1 to 1 of 1

Conditional Formatting on Pivot Rows - Not Applying to all rows

Threaded View

  1. #1
    Registered User
    Join Date
    09-25-2020
    Location
    Louisville
    MS-Off Ver
    365 Pro
    Posts
    29

    Conditional Formatting on Pivot Rows - Not Applying to all rows

    SOLVED: I figured out the solution to this problem. It was not immediately obvious, but a blank in one of the columns would not allow the conditional formatting to apply for that entire row for below average values. Setting the pivot table to display 0s for blank values corrected the issue and the formatting was applied to every row.

    Conditional Issue.png

    I am experiencing an issue when trying to apply conditional formatting to rows within a pivot table. Unfortunately due to the nature of my business I cannot share this exact workbook, however I attached an image and will describe the issue. The pivot data is by location, with a handful of measures under each. I wish to apply conditional formatting (fill) to each pivot row of a certain measure indicating whether or not that number falls below the average for that same row. When I apply the conditional formatting it works for only some of the rows in question, but does not apply to all of them. When it applies correctly, the highlighted values are correct for that row's measure, so I know that the conditional formatting was applied correctly, I just don't know why it is not applying to every row. Has anyone experienced a similar issue?
    Attached Images Attached Images
    Last edited by Beefhamburger; 01-11-2022 at 01:38 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 12-08-2016, 03:14 PM
  2. Conditional Formatting rows in Pivot Table HELP!
    By kfryar in forum Excel General
    Replies: 1
    Last Post: 03-26-2014, 01:26 AM
  3. Replies: 6
    Last Post: 02-16-2012, 04:52 PM
  4. Replies: 8
    Last Post: 04-25-2011, 09:37 AM
  5. Replies: 3
    Last Post: 04-05-2010, 04:25 PM
  6. Applying Conditional Formatting to Multiple Rows
    By dcaldwell86 in forum Excel General
    Replies: 1
    Last Post: 10-02-2009, 09:32 AM
  7. Applying conditional formatting to ODD rows
    By SirSFZ in forum Excel General
    Replies: 0
    Last Post: 03-31-2005, 10:46 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