I have a row of a pivot table as shown in the picture. However, is there a way to make it so that if the values are different when comparing the last four rows, it will highlight the row?
If possible an even better solution would be to highlight the cell that is different AND has the least frequency number. For instance, say in the last 4 columns when looking at one row, the values are shown as '4', '4', '5', '4' - only highlight the cell that has the 5 in it because yes it is different but it also shows up the least number of times.
Any help would be hugely appreciated. Please let me know if there are any issues with seeing the image.
Apologies for the lack of detail.
1) It would be preferred that the ROW get highlighted and not the whole table itself.
2) Good pickup - lets scrap the idea of highlighting an individual cell, instead if there is a difference in the last 4 cells in a row, highlight the whole row.
In this example, since the last 4 cells of the second row are different. It should thus have the whole row be highlighted
OK try modifying this approach
You would need to add a multi-value to every column that you want colouring
Hi @ITWhisperer , thank you so much for the help. However the problem has changed slightly. I'm trying to apply this to dynamic fields in a pivot table. I've asked an additional question here as to not go to far outside the scope of this thread.
I'd be incredibly grateful for any help I can get with this newer more detailed question ^