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?
Bookmarks