Hello,
I would like to put some colors into my pivot table at some lines, but when I change the filter value (let's say it was on month number "1" and I put it on month number "2"), it lost all colors.
I have tried to do right click and then "preserve cell formatting on update", but it doesn't work.
I'm on Excel 2016.
Regards,
Jan