Conditional Formatting in a Pivot Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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....
 
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.
 
Thanks. I have 2007 so it works.

Debra Dalgleish said:
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.
Click to expand...
 
Back
Top