Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional Format and Pivot Table
I have a pivot table and some conditional formatting associated with it.
Everytime I refresh the pivot I lose my conditional formatting. Is there a way to save the formatting so that when I refresh the pivot it stays? TIA! |
#2
|
|||
|
|||
Conditional Format and Pivot Table
You'll see that message if you're using Excel 97, and there's no way to
make it stick. In later versions, you can apply conditional formatting, and it will stay in place after a pivot table refresh or change. However, it stays with the original cells where the formatting was applied, and doesn't move with the pivot fields. You could record a macro as you refresh the pivot table, and reapply the conditional formatting, then run that macro as required. Jenn wrote: I have a pivot table and some conditional formatting associated with it. Everytime I refresh the pivot I lose my conditional formatting. Is there a way to save the formatting so that when I refresh the pivot it stays? TIA! -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I format a pivot table column - permanently? | Excel Discussion (Misc queries) | |||
Keep conditional format when "show pages" from Pivot table | Excel Discussion (Misc queries) | |||
Excel - pivot table - how do i format cells with data mm/dd/yyyy . | Excel Worksheet Functions | |||
Conditional Formating on calculated data in a pivot table | Excel Worksheet Functions | |||
Format a Pivot Table | Excel Discussion (Misc queries) |