I have a Pivot Table that currently changes the colour of items marked "1" for different categories. For example, fields within HIGH become red, MEDIUM is orange, and LOW is yellow.
This worked great when I only had three "row label" items, but now I wish to add a fourth containing additional details within the Pivot table. The result is that only certain rows have their colour changed, yet I want the remaining 1's font colour turned white so they don't show.
A before and after screenshot below explains what I mean.
After adding the detail row label:
If the font colour of those remaining number 1's were changed to white so they don't show it would look like this:
Once this has been applied I will be changing the layout back to "Compact Form", where I know it keeps the changes made to font colour:
It needs to be done programmatically using VBA because there may be more rows and columns depending on the source data.
I've attached the Macro enabled spreadsheet here:
Many thanks in advance,