I have a Pivot Table that currently has performance results conditionally formatted by value using a 3 color scale (red/yellow/green).

I have read a lot already to find a solution on making these colors permanent, but haven't found a solution.

In Pivot Tables, I know the CF follows the structure of the table, and not the cell, so when I filter any of the results, the CF adjusts to reflect the remaing visible cells. For example: my lowest value is 0% (this will be red), midway is 50% (this will be yellow) and highest value is 100% (this will be green), with values in between transitioning between red, yellow, and green.

If I filter my results to now have only a few cells showing, lets say results of 25%, 33% and 75%: 25% used to be reddish yellow, is now red; 33% also used to be reddish yellow is now yellow, and 75% which used to be yellowish-green, is now green. I don't want the colors to re-evaluate: I want them to stay 25% as reddish yellow, 33% to stay reddish-yellow, and 75% to stay yellow-ish green.

I only want the CF to establish the scale when all values are considered and those colors to hold even when I use filters (this is so I can filter to just the specific results I want, while visually being able to see how they compare to all the results)

After looking into this already, I believe there to not be any options in the pivot table itself to not re-evaluate the colors, or to otherwise make them permanent.

The solution that will work is using fill color instead of conditional formatting. I need help writing a macro that will look up what color each value has been assigned by the 3 color scale conditional formatting and change the color property of that cell to that color, the same way as if I used Fill Color. In this way, I can take advantage of CF to determine the color, but Fill Color will make it part of the cell instead of the pivot table. I have a huge range, E2:Q4285, so I would need it to run through 55,000-some cells, though it could be split up if that makes it easier.

To summarize, I need help to make a macro that will:
1. identify what color CF has already assigned
2. use Fill color on that cell with the color assigned by CF (essentially convert CF to fill color)
3. automatically repeat for the whole pivot table for all cells with numeric values

Any help with any of these aspects would be extremely appreciated!