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.

        .PivotSelect "'Recovery Rate '", xlDataOnly
            With Selection
            .FormatConditions.Delete
            .FormatConditions.Add Type:=xlCellValue, Operator:=xlEqual, Formula1:="0"
            .FormatConditions(1).Interior.ColorIndex = 37
            .FormatConditions.Add Type:=xlCellValue, Operator:=xlEqual, Formula1:="'0%'"
            .FormatConditions(2).Interior.ColorIndex = 37
            End With

Any pointers in the right direction would be much appreciated.