Hello everyone,

I'm having trouble with a dashboard i'm creating. The background color is set to white for all cells in the sheet.

I create a simple pivot that shows the evolution by ctry let say and add a slicer so that the user can select the country/countries he wants to see. There is also a pivot chart linked to the pivot.

The trouble is when he selects i.e. 4 countries the table will show 4 columns. Afterwards if he selects only one, the columns where the pivot used to be lose format, while i want them to keep the white background format.

I've attached a pic of what i mean hope it clears things.

Been struggling with this for quite a while on different ocassions.

Thanks for your help! 2015-08-05_113841.jpg