Conditional Formatting in a Pivot Table

[Jon Dow]

Can you do a conditional format in a pivot table? For instance, for each
value in the table over 1000 shade that cell red and for each over 5000,
blue....

 

[Debra Dalgleish]

You can add conditional formatting in a pivot table in Excel 2007.
For earlier versions, you can add conditional formatting to the cells,
but it won't move if you change the pivot table layout.

 

[Jon Dow]

Thanks. I have 2007 so it works.

You can add conditional formatting in a pivot table in Excel 2007.
For earlier versions, you can add conditional formatting to the cells,
but it won't move if you change the pivot table layout.