Have you looked into Conditional Formatting ?
"Slickwillie" wrote in message
...
After creating subtotals, I would like excel to automatically hightlight
the
subtotal row in a different cell shading. Is this possible? If yes, How?