Advanced Excel Q

[flamingchina]

I'm trying to figure out how to created banded rows in a pivot table in Excel 2003.
It's easy to do in 2007, but alas, work doesn't have that.
Anyone have any ideas?
The usual conditional formatting method used for regular worksheets doesn't work.

[Bend it like Bourgeois]

try format>>>autoformat in the drop down menus

It won't adjust them when you sort though.

thsi website is great for all things excel....
http://www.mrexcel.com/forum/index.php

[flamingchina]

Nah, none of those are what I actually need.
I'll look around that forum