When I enter new data into my table and hit refresh on the Pivot Table, all the conditional formatting disappears. The PivotTable has been named and the conditional formats have been applied to that specific PivotTable. Please tell me how to prevent this from happening!