Hi Amy,

the easiest way to accomplish this is to choose from one of the pivo
table's autoformatting options. To do this, right-click anywhere on th
pivot table, select "Format Report" and choose one of the options tha
shows alternate column background colors.

Hope this helps

--
Kre
-----------------------------------------------------------------------
Krem's Profile: http://www.excelforum.com/member.php...fo&userid=2434
View this thread: http://www.excelforum.com/showthread.php?threadid=37943