On the attached file I have a pivot table where I need to apply conditional formatting. What I am trying to do is that for example if there is a value 1 in the cell AB17 then the cell I17 cell should turn red. I achieved this on another pivot but for whatever reason I just can not obtain the same results on this one. Format should be applied to the entire pivot table starting from I13 cell all the way down to W8000. Along with your solution if you could also describe your steps I would truly appreciate it as I need to put this in a macro. You can find a macro that worked on my other pivot table except on this file its range has been modified for this pivot. Macro name ConditionalFormat. Not sure why it does not work here at all.
Thank you very much in advance