Log In
Register
Home
Active Member
November 15, 2018
Offline
I've got a pivot table that I have put conditional formatting on a number of columns, namely if under a value, format in bold red, and if over a value, format in bold green.
Having only just found the nifty show report filter pages option to split out by my filters (hallelujah) is there a way to retain that formatting??
I suppose my only other option would be to create some macro button that I can do the formatting quickly but I'm not quite sure how I would do that as the column sizes will all be a little different.
July 16, 2010
Offline
Hi Sue,
Unfortunately, there's no way to copy the formatting when you use 'show report filter pages'. The macro will be the way to go.
I would record a macro and then if you get stuck editing the VBA to allow for different numbers of columns, reach out in a new post in our VBA forum.
Mynda
1 Guest(s)
