Changing the color of the whole column in a pivot table based on selection

[Anonymous]

Hello community,

I have a pivot table with two dimensions: product (rows), and time (columns). I've used set analysis to keep all the columns regardless of the selection of time. However, I want the column for any particular time period to change color once the user chooses that column. Any ideas and suggestions are appreciated.

[Gysbert_Wassenaar · Accepted solution]

See attached example

[Anonymous]

Thank you Gysbert! This worked perfectly.