Format subtotal rows
 

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

Format subtotal rows
 

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" wrote in
message ...

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

Format subtotal rows
 

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