Keeping original data format in a pivot table

  • Thread starter Thread starter Angelica Thomas
  • Start date Start date
A

Angelica Thomas

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.
 
Without more information, I would say you at least need a macro that colors
the cells red, yellow and green.

Regards,
Tom Ogilvy
 
Back
Top