Pivot table formatting

Question

I have several pivot tables and formatted the color and fonts. When I change the filter or add any data, I lose the formatting. I have tried going to pivot options and selecting preserve formatting, it doesn't work for me. Please help if anyone knows the answer. Thanks!

Answer 1

You might be able to use conditional formatting instead of formatting individual cells. I have a pivot table that tracks if deadlines are missed:

Select a cell you want to format, go to conditional formatting, and click on "New Rule". Then, you can select which cells you want to format (in my case, the second option), chose your criteria (for me it was if the date is greater than the column next to it on the left), and set your formatting.

My formatting remains regardless of what I add to the table. If you add different columns or cells you want to apply rules to, you'll need to create new formatting rules for those. But, if your columns are fairly consistant, this might do the trick.