I am using office 2007. I have created Pivot Table. Column A which is called
"Area" has a filed setting set up as "Automatic" as subtotal. Pivot has
columns from A thru F. I like to use conditional formatting to high light the
rows from A thru F where there is a sub total on the rows.

Dinesh