In , David McRitchie
spake thusly:

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.

Thanks, David. I'm not sure what you mean by "change a Ctrl-A";
Ctrl-A selects the entire sheet regardless. I don't normally
select the subtotals row, I just click on a plus sign and expand
the group rows. The subtotal row was and remains visible just
below. It's just that other subtotal rows are all crammed
together just below that, and visually it's not the best for
instantly distinguishing which one should have my attention at
the bottom of a variable-length group of rows that just got
expanded.

In any case, when I try Alt-; , it says only visible cells are
already being displayed.

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

I'll look at your site. I just looked at all the toolbar buttons,
including the non-displayed ones, but I don't see the one you mean.

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

I have the formatting the way I want it already for all the cells.
I just thought when I click the plus sign to open a collapsed group
of rows, the row just below -- which is my subtotal row -- could
change its color.

By the way, I see you quoted another poster, but I don't see his post
in the thread on my news server. I will respond to him here as well.


"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...

Jim, thanks -- as you see above, your post did not make it to my
server. Not sure why. But I already have the formatting fine.
I merely want the color to change for my convenience. Here is my
thought on events: The event would be that the row just above the
subtotal row is now visible instead of hidden.

Thanks for any more ideas,
dman

================================================== ==========
"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.