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.

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.

(Column A had my category and I used Sum in Data|subtotal)

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

--

Dave Peterson