Conditional Formatting in a Pivot Table
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.... |
Conditional Formatting in a Pivot Table
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 wrote: 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 Contextures http://www.contextures.com/tiptech.html |
Conditional Formatting in a Pivot Table
Thanks. I have 2007 so it works.
"Debra Dalgleish" wrote: 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 wrote: 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 Contextures http://www.contextures.com/tiptech.html |
All times are GMT +1. The time now is 09:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com