In , Dave Peterson
spake thusly:

Maybe it would be easier to just bold/color those rows with
subtotals in them.

You can do it manually:
Collapse the data so you only see the rows you want specially
formatted.
Select all the table
edit|goto|special|visible cells only
apply the formatting to those visible cells.

Yes, thanks, Dave; I appreciate the ideas. It so happens I
already implemented both of these. :-)

If you aren't using format|conditional formatting, you can pick
out a column that has a the Total or Count or Average (whatever
subtotal you used) word in it.

Then select the whole range and do
format|conditional formatting
formula is
=countif($a1,"*total")0
Give it a pretty format.

And that's already been done as well. But I'm feeling in good
company to have thought of these things you're proposing! <vbg

I'll keep your mention of the xl2003+ stuff in mind as well. Thank
you again.

=dman=

=======================
ps. when you get xl2003+, you might want to try
selecting the range (avoid the headers (in row 1 for me)
Format|Conditional formatting:
formula is:
=subtotal(103,$A1)0

The ability for subtotal to work on manually hidden rows was
added in xl2003.


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