• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Changing Pivot Table Background Color to Grey

ExcelfromGermany

New Member
I customized my pivot table by setting the background color to light grey. However, each time I refresh the data, if there's a decrease in the amount of data, the background color reverts to white. How can I ensure that the background color remains light grey regardless of how many times I refresh the data?
 
Use a pivot table style with whatever formatting you need, rather than formatting cells specifically.
 
Back
Top