Frederick,

My Excel add-in "Shade Data Rows" seems to work on Pivot tables.
I just tried it out on a pivot table as have never had the need.
It shades groups of like valued rows or by every nth row.
Does the selection width or the entire sheet width.
Choice of colors and an option to skip hidden rows.

Comes with a one page Word.doc install/use file.
Free upon direct request. Remove XXX from my email address

Regards,
Jim Cone
San Francisco, USA
XX


"Frederick Chow" wrote
in message ...
Hi all,
Is it possible to do colour banding in pivot tables? I have searched all
avaible AutoFormat and I could find none, nor could I do it using
conditional formatting. Thanks a lot.
Frederick Chow
Hong Kong.