Assuming you used Data - subtotals to insert your subtotals then you can use
Format - AutoFormat and select a format that you like... If you did not use
Data - Subtotals then you can still try autoformats but there is no
guarantee that it will work out correctly...
--
HTH...

Jim Thomlinson


"Diane" wrote:

How can I automatically (not manually) highlight or shade all subtotal rows?