0
I have a report (several actual) with Pivots that appear to have conditional formatting (each cycle week is color coded), but there are no rules for any part of the workbook. The reports contain some macros but none of the VBA references any type of formatting. When I add new data to the pivot source and refresh, the cycle week on the new rows in the pivot is formatted just like the previous data (implying there is conditional formatting on either the column or the pivot).
In summary: no conditional formatting under 'manage rules', nor any VBA that would format; how do I modify or remove this formatting without recreating the entire report?