I have multiple pivot tables that depending on the data i'm showing some weeks will uses 3 rows. some weeks 10. when i show weeks only using 3 rows i get the no colour background of excel instead of the background colour i added. is there a way to ensure the background colour always stays the same?