Hi,
Is it possible to do conditional formatting of a pivot table based on 80/20 percentage. For example I have a pivot table as below. It is showing the cost values by category and country
want three kind of conditional formatting based on 80/20 expression
1) For each cell in row(Category), If the cost contributes to the 80% of total cost for that row, format the background to be yellow
2) In another copy of the same table, for each column (country) I want the background of a cell to be colored orange if the cost amount of that cell contributes to the 80% of total cost for that column (country)
3) In another copy of the same table, I want the background of a cell to be colored red, if it contributes to the 80% of the overall cost (All categories, all countries)
I will appreciate if someone can help me in this as I am struggling to find a solution for this
Shah