Presentation

[Kebede]

I have a huge file that I had to sort and put sub-totals. I do not wan
to show the details between subtotals. What kind of formula or ste
would allow me to print ONLY the subtotals? I will also like to pu
different shades at the subtotals. Is this possible through a formul
or do I have to do it line by line? Any info shared in this regard i
hugely appreciated.
Thanks in Advance
As

 

[ryguy7272]

One you have the subtotals in there, you can filter on subtotal, right. With
just the subtotals displayed, copy/paste to a new sheet. Use this technique
to shade the alternate rows:
http://www.techonthenet.com/excel/questions/cond_format2.php

HTH,
Ryan---