Hi all,
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.
Please can you clarify if you want to highlight the different cell in each row or the whole table? Also, what if there are two cells which are different 3, 4, 4, 5, which cell to highlight?
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
foo | bar | 4 | 4 | 4 | 4 |
goo | car | 4 | 4 | 5 | 4 |
Try something like this
<format type="color">
<colorPalette type="expression">if(col1==col2 AND col3==col4 AND col2==col3,null(),"#53A051")</colorPalette>
</format>
Hi @ITWhisperer
Tried the recommended approach and it would highlight the whole table in green.
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 ^