Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional if or filtering in pivot table | Excel Worksheet Functions | |||
Pivot table formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting of Pivot Table Field | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) | |||
Conditional Formating on calculated data in a pivot table | Excel Worksheet Functions |