During your selection of totals, you can change a
Ctrl+A (select all) though you may have to play with hitting
that a few times in newer versions of Excel.

Then use ALT+; (semicolon) to
Select only visible cells in the current selection
our use the toolbar button that has four black rectangles on it.
http://www.mvps.org/dmcritchie/excel/shortx2k.htm

Then any formatting you apply will only apply to those visible cells.

--
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Jim Thomlinson" wrote in message
...
Since expanding and collapsing is not a recognized event this is a real up
hill battle. How about just applying a Format - AutoFormat to the subtotals.
That should help you get some physical deliniation between data and
subtotals...
--
HTH...

Jim Thomlinson


"Dallman Ross" wrote:

I have a sheet full of grouped rows with subtotal rows at the
bottom of each group/set. When all the groups are collapsed,
I see only the subtotal rows. When I expand a group, I have
a bit of trouble visually distinguishing that group's subtotal
row from others just below it. I would like to code some
sort of event code that changes that subtotal row's color if
the group is expanded. Is this possible within reason?
I'm using Excel 2002.

--
dman