Just noticed this question was answered by Debra Dalgleish in a 1/16/2007
post - in Excel 2003, it's not possible to apply conditional formatting to a
pivot table so it maintains it's integrity when the pivot table is
manipulated - however, it appears that Excel 2007 does provide this
capability ...

"WCM" wrote:

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