Have you looked at the auto formats that come with pivot tables. On the
Pivot Tables Toolbar there is an icon that looks like a table with a
lightning bolt. There are a bunch of predefined formats that work great. They
format the entire table quick and easy.
--
HTH...

Jim Thomlinson


"Schwimms" wrote:

Presentation purposes.

"Jim Thomlinson" wrote:

What are the highlight being used for. Are you highlighting exception data or
are you just trying to format the table for presentation purposes???
--
HTH...

Jim Thomlinson


"Schwimms" wrote:

Hi,

I am having trouble in a pivot because when i change a criteria I lose all
the colors I have in the pivot, is there a way I can make the colors stick?