Jed Shields
Active Member
- Joined
- Sep 7, 2011
- Messages
- 283
- Office Version
- 365
- Platform
- Windows
Hello all,
I've got a load of pivot tables on a sheet and have coloured all the surrounding cells white to make the page look better. However, when I use a slicer to change what the pivots show, when they reduce in size the cells left showing have no fill. I've manually filled them and also tried using conditional formatting but they still show with no fill after the pivots change size. Is there a way of fixing this?
Cheers,
Jed
I've got a load of pivot tables on a sheet and have coloured all the surrounding cells white to make the page look better. However, when I use a slicer to change what the pivots show, when they reduce in size the cells left showing have no fill. I've manually filled them and also tried using conditional formatting but they still show with no fill after the pivots change size. Is there a way of fixing this?
Cheers,
Jed