ExcelBanter - formatting subtotals

Works like a charm - thanks!

"Frank Kabel" wrote:

Hi
after collpasing the data and selecting the data try:
- hit F5, choose 'Special'
- select 'Only visible cells'

Now apply your format

--
Regards
Frank Kabel
Frankfurt, Germany

S. H. Drew wrote:
When using the "subtotals" function, the subtotal description gets
bolded...but not the figures in the subtotal (example below). Is
there anyway to change this? I want the results of the subtotal to
be bolded, or otherwise highlighted. But when I collapse the
spreadsheet to show only the subtotal results, and then highlight the
subtotal figures and make them bold, all the detailed data in between
the subtotal figures gets bold too.

(these get bolded) (these do not, but I want them to be)
4140 011 2311 Total 2
4137 222 0000 Total 5
4137 223 0000 Total 7