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???

Louise wrote:

When subtotaling a large worksheet is there a way to color and line the
subtotals at the same time.

Hope someone can help

Louise

--

Dave Peterson