pivot table conditional formatting based on 80/20 percentage
Hi,
I have a pivot table where I have categories on rows and countries on columns. I have presented the cost by each category and country. Take a look at the below table for example
I want three kind of conditional formatting here
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)