Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Keeping original data format in a pivot table
I wrote a macro to convert my data into red, yellow, or
green cell colors based on the value. Now I want to add a pivot table macro, but when I do that the cell format is lost. All of my data cells have a white background in the pivot table. Is there any way to keep my colored cells, or do I need to write a unique macro to convert my three columns into a table format? Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Keeping original data format in a pivot table
Without more information, I would say you at least need a macro that colors
the cells red, yellow and green. Regards, Tom Ogilvy "Angelica Thomas" wrote in message ... I wrote a macro to convert my data into red, yellow, or green cell colors based on the value. Now I want to add a pivot table macro, but when I do that the cell format is lost. All of my data cells have a white background in the pivot table. Is there any way to keep my colored cells, or do I need to write a unique macro to convert my three columns into a table format? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table and adding a % column, that is not in original data | Excel Discussion (Misc queries) | |||
Pivot Table - add new group to original data | Excel Discussion (Misc queries) | |||
Sort pivot table field (droplist) by month or original data | Excel Discussion (Misc queries) | |||
Original Pivot Table Defaul Format | Excel Discussion (Misc queries) | |||
How do I restore original Pivot Table data? | Excel Discussion (Misc queries) |