Hi all,

I read up a little tip the other day that helps you to distinguish subtotals quickly without code. I know of many posts that have dealt with Conditional Formatting to highlight totals etc, (and yes this does make it more dynamic...). But if you just want to highlight subtotals quickly without the fuss of setting up conditional formats, then simply apply AUTOFORMAT to the list. Select a cell in the list and choose Format | Autoformat. Select any format and this does a sparkling job on the list!!
<img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>