I have a worksheet which I have highlighted certain rows of in various
colours which represent various things to me.
How can I turn the worksheet data into a pivottable and get it to keep the
colour formatting that is applied to specific rows? I've scoured this forum
and nobody seems to have ever experienced this problem.

I don't want to have to go through the entire pivot report and redo all of
my work.

Hope somebody can help.
Thanks
Elinor
Brisbane, Australia