Create different Excel files / sheets based on a Table slicer

[elisadovio]

Hello,
I've created a file where I have a Table with a Conditional Formatting applied providing an overviewing of course completion on all countries. (image attach)
I would like to create automatically a new excel (or at least a new sheet) for each Country of the Table slicer.

I tried first using a Pivot table, apply the conditional formatting and then using the "Show Report Filters Pages", the problem is that the Conditional Formatting was lost.

Any ideas on how I can do this step of creating different a different excel file for each Country?

thank you,
Elisa