Conditional Format - Pivot Table
Hi ...
Is there any way to apply conditional formatting to a pivot table 'Data'
field so that if the user manipulates the pivot table, the formatting will
remain in tact even if the column position for that field moves to the left
or right?
I can use conditional formatting to format the entire column, but if that
pivot column moves to the left or right during user interaction, then the
conditional formatting stays in the original column, just as if the
conditional formatting were applied to a normal spreadsheet.
Thanks ...
Bill
|