Excel Pivot Table Remnants

[NOT_PROVIDED_354]

When a pivot table is updated and the number of rows/columns is reduced (the table is contracted), how can I keep the formatting of the previously occupied cells the same as the pivot table background color. Now when the table is contracted the empty cells are blank.
i.e. When the table contracts, I want the cells that used to have data in them to be filled with a certain color.

 

[Ralston18]

Try conditional formatting. I.e., any cell that is empty/blank is changed to the certain color.

Will have to apply conditional formatting to all of the cells in the orginal table.

 

[Jace__]

Try conditional formatting. I.e., any cell that is empty/blank is changed to the certain color.

Will have to apply conditional formatting to all of the cells in the orginal table.

Brilliant. I was definitely overthinking that one!! Thanks!