First, if you don't get an answer, then the usual problem is that people don't
understand the question--or the solution would require way too much time for the
typical responder (and maybe hiring a consultant would be a good idea).
Second, instead of starting a new thread, you could have posted a followup with
more information -- but in the same thread.
Third, I don't think that there's anything built into excel that would allow you
do to this.
The closest thing I could see (but I don't completely understand what you've
done) is that you could use the worksheet_Calculate event and look at the rows
that are visible and apply some formatting that way.
But since you could expand the collapsed rows to show all the details, I'm not
sure how you'd approach exactly what you want.
As an alternative, you may want to look at Data|Pivottables.
You can get that nice summary and you can drill down to just the rows that were
used to create that total/sum/average...
I wish we could use screen shots here.
What I have been ask to do is this: You have the layout of a typical
subtotal. The "two" view is selected or collapse to only show the "totals".
What I did was populate the blank cell to right of the subtotal to show data
from the list. When my user click on the "+" button it will expand the
subtotal showing the rest of the data. So, what I been ask to do or find out
how to do this: when the user click on the "+", it will gray out or color the
cell all white above and below it to only show the data that is expanded.
I hope the make since, if not I can email a video showing what I need.
Thanks for the help. And yes, I did post it twice. I would be nice if
someone would just answer back with "can't be done" that way, we know someone
read it.