Hi Experts,

I wrote macro to create pivot table and its working fine. Now am thinking if I can color the pivot table / format it with custom colors and borders etc., through VBA or do I have to copy contents of Pivot table to new table to apply colors?

Below is the screenshot of Pivot Table:
T1.JPG

I want to format pivot table (if possible) or create new table based on the pivot values to below table:
T2.JPG

Pivot table cells will always starts from A33 but number of rows will vary. It may grow or shrink.

I will really appreciate any help provided.

FYI: I tried to google and go thru some websites but no help.

Thanks,
Richa