The pivot table takes over the area you put it in, and overwrites the format you had in there before. Maybe if you conditionally format the area with condition Cell Value Is >> Equal To >> ="" , then perhaps you can maintain the background... but it might also affect some cells within the Pivot Table....
Bookmarks