Joanna, the first step is to get the macro changing the colours as you want it to, then we can look at how to trigger the macro.

You need to remove the conditional formatting in the sample you sent me, and remove all fill colours from your pivot table, then run the macro. Does this give you the result you want?