Conditional formatting for a PivotTable field
 

Hello,
Is there a way to conditional format a field (not the data) in a PivotTable
in Excel 2007?
I have a PivotTable with following columns: €œBudget€� and €œActual€�. I want
to conditionally format the €œBudget€� column to have a red fill if it is
smaller than the €œActual€� column. If I do it by conditionally formatting the
whole column, once I move the fields to different columns, the conditional
formatting is lost. Is there a way to keep it?

Thank you,
EH