Pivot tables: conditionally formatting based on all cells total


For a sample pivot table as per picture


can anyone please let me know if there is a way to do conditional formatting where the lower values are colour coded separately to the higher values relative to all the other values in table (similar to the picture)? I need this to be applied across all the values in the table.


yes you can make a calculated field and conditionally format by it.

Something that might work is a percent of total, or you would need to build out your own logic.

Hi Max - thanks for the suggestion. In the real table I would have 10+ columns, so would your solution involve creating 10+ percentageOfTotal calculated fields or is there a more efficient way? Thanks

You would have to do that if you want to have conditional formatting like above for each.