Is it possible to add conditional formatting in a pivot-table?
Hi all!
I wonder if it is possible to add conditional formatting features to highlight certain data within a pivot-table. All I could do until now is to highlight the data I want via the normal way. That is, adding conditional fomatting conditions to a group of cells, but when I change the pivot layout, I lose everything. Thanks for your help! Raphael |
Is it possible to add conditional formatting in a pivot-table?
You can't add conditional formatting to items or specific data in a
pivot table. It's applied to the cells, and may show incorrect results if the pivot table layout is changed. Saddy wrote: Hi all! I wonder if it is possible to add conditional formatting features to highlight certain data within a pivot-table. All I could do until now is to highlight the data I want via the normal way. That is, adding conditional fomatting conditions to a group of cells, but when I change the pivot layout, I lose everything. Thanks for your help! Raphael -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
All times are GMT +1. The time now is 11:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com