Conditional Formatting Pivot Tables VBA

HI i am trying to do a conditional formatting for all values in the "PvtTbl.PivotFields("Percent")" for
between 0 to 0.05 in red, 0.051 to 0.15 = green and 0.151 to 1 in yellow.


this is my code adapted from globally connect.com..

Please Login or Register  to view this content.

bump, this was the recorded code , just need to know how to select only the values of .PivotFields("Percent")

what am I missing here?

Please Login or Register  to view this content.