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

Hi,

If you are using Conditional Formatting in your original worksheet,
Format painter should help ...
otherwise, there is no real solution ... but to redo formatting and
then make sure pivot table preserves this work ...

HTH
Cheers
Carim