Forum Discussion

bhola prasad's avatar
bhola prasad
Copper Contributor
Aug 22, 2017

Conditional formatting on different level in Pivot table in excel 2016 for mac.

Can anyone help me with conditional formatting on a different level in a pivot table?

 I have 3 levels - Product category > Sub Category > Product. I want to apply conditional formatting to only relative to the products cells. In Windows, I have seen that you can easily do just by formatting one cell then right click on the drop-down box and select the level you want to apply the same conditional format. but I can't able to do or find out how to do it in excel 2016 for mac.

No RepliesBe the first to reply

Resources