Pivot Table - Conditional Formatting

Hi Guys,

I'm stumped at the moment in trying to get my conditional formatting working on my pivot table.

It seems to be working when a result equals 0 but when trying to match the text of 0% it inserts the ' on either side and therefore doesn't work but I assume the ' is needed to notify Excel it is a string.

Please Login or Register  to view this content.

Any pointers in the right direction would be much appreciated.