Format subtotal rows

[nihad]

I'm trying to find the easiest way to format the rows containing subtotals only. If i just reduce the group to only see the totals and format that, it formats the rows in between as well. Is a macro or conditional formating easiest?

[Bob Phillips]

CF is easiest, but you may be limited in what you can do. Bold yes, font
size no.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"nihad" <[email protected]> wrote in
message news:[email protected]...
>
> I'm trying to find the easiest way to format the rows containing
> subtotals only. If i just reduce the group to only see the totals and
> format that, it formats the rows in between as well. Is a macro or
> conditional formating easiest?
>
>
> --
> nihad
> ------------------------------------------------------------------------
> nihad's Profile:
http://www.excelforum.com/member.php...o&userid=30285
> View this thread: http://www.excelforum.com/showthread...hreadid=500198
>

[Dave Peterson]

Hide the details
select the range
edit|Goto|special|visible cells only
format the cells.

nihad wrote:
>
> I'm trying to find the easiest way to format the rows containing
> subtotals only. If i just reduce the group to only see the totals and
> format that, it formats the rows in between as well. Is a macro or
> conditional formating easiest?
>
> --
> nihad
> ------------------------------------------------------------------------
> nihad's Profile: http://www.excelforum.com/member.php...o&userid=30285
> View this thread: http://www.excelforum.com/showthread...hreadid=500198

--

Dave Peterson