Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

PivotTable formating

Status
Not open for further replies.

peachmelba

Programmer
Jan 4, 2002
43
GB
I need soem help formating a dynamicaly generated pivot table in Excel 97 from and Acess 97 database.

What I would like to do is change the back colour of the groups. For instance I have three levels of grouping b) Product, b) Scenario and c) Test Group.

What I would like to do is give each group background colour a different shade including the totals. I have looked at Microsoft and other areas but they have not been much use.

Please help this is strating to drive me mad.

Regs

Peachmelba

[sadeyes]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top