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.
