E
EH
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
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