View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
WCM WCM is offline
external usenet poster
 
Posts: 59
Default 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