Apr 20 2022 09:37 PM
Dear good afternoon, I hope you are well.
I need your help, I have the following pivot table, where I want to hide in the "variation" column the zero values and the negative values and in another table the zero values and the positive values, then extract from the pivot table In mention.
Attach file
thanking you in advance for all your help.
Blessings,
Apr 21 2022 12:47 AM
Hi @Divasmo
- Select one of the Variacion "column" (both will be auto. selected):
- Go to Home (tab) > Conditionnal Formatting > New Rule... > Set the rule as below:
- Click Format > Number > Custom: ,,,
Apr 21 2022 07:28 AM
Apr 21 2022 11:14 AM
Much more clear: you want to hide the rows where the [Varicion] is > 0 (or < 0 in the other Pivot)
Good question...