Using VBA to Apply Colour Scale Conditional Formatting to a Pivot Table

[Manuel_Spreadsheet]

Hi all -

I've got a pivot table setup that pulls from my workbook's data model. I've got a macro setup on it that allows me to swap out the values field from one of three options. That's working well but I lose my conditional formatting when swapping in a new values field. So, I'd like to include some code at the end of the macro that applies the conditional formatting. Specifically, I'm trying to accomplish the following:

• Apply a green, yellow, red color scale
• Apply the color scale only to the values themselves, not the total column or total row
• Use the following thresholds for the colors: red = 5th percentile, yellow = 50th percentile, green = 95th percentile

Any guidance or sample code to make this happen would be greatly appreciated.

Thanks!