Conditional Formatting in a Pivot Table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jon Dow - 23 Feb 2007 05:09 GMT

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....

Reply to this Message

Debra Dalgleish - 23 Feb 2007 06:27 GMT

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.

> 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....

Signature

Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply to this Message

Jon Dow - 23 Feb 2007 14:51 GMT

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,
[quoted text clipped - 3 lines]
> > value in the table over 1000 shade that cell red and for each over 5000,
> > blue....

Reply to this Message