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
|