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.