Hello,

I currently have a subroutine that basically executes contiional formats on
a pivot table. I was wondering if there is a way that if a user changes the
page field that I can remove all of the formats and then re-run the routine
for the newly displayed data.

Thanks in advance for your assistance.
John