On the pivot table toolbar there is an Auto Format that gives you a bunch of
options in terms of colouring and formatting your table...
--
HTH...

Jim Thomlinson


"PTKing" wrote:

Hi,
A novice question:

How can I automate the colours used in a pivot table?
--
PTking