Hello!

I have a pivot table that has 3 columns in it for a rolling 3-month view. The 3 columns are January, February, March. Within the pivot table sigma (sum) of values, I have percentages ranging from 0%-100%. A color has been assigned to each cell based on its value using conditional formatting (this pivottable).

The following color allocations are:

if x = 100% -->Dark Green
if 80% < x < 100% --> Green
if x < 80% --> Red


I found the following URL link that shows you how to use the Autofilter for a pivot table instead of using the Report Filter. This post does EXACTLY what I am looking for, however, my pivot table has Grouped Items in the columns. The user can expand the columns which will show the weeks that are included in each month. When I use the Autofilter as the article states, it actually hides my column groupings for the pivot table. How can I trick Excel (probably through VBA) to filter the color AND keep my pivot table headers?!

Any thoughts?