I am having trouble with my conditional formatting in my pivot table. When I refresh my data, usually half of the conditional formatting erases (I have certain dates filled by background color)... I then have to format paint everything to get it back, but when I refresh it is gone again.
Any ideas as to why this is happening?
Thanks
Bookmarks