would like each subtotal line highlighted

J

Jim Thomlinson

Have you looked at Format -> Auto Format... It usually does a nice job of
formatting sub-totals.
 
D

Dave Peterson

Apply the data|Subtotals
Use the outlining symbols to the left to hide the details
select the range to modify
Edit|goto|special|visible cells only

apply the formatting you like to those visible cells

Then show all the range???
 
Top