subtotal formatting

A

ab3d4u

I know I can show different levels by selecting the the (1,2,3,,, etc
layers created by the subtotal process. I just do not know how to sho
the subtotals in different colour(s) and possibly by inserting a blan
line in between the subtototals. No need to show details. Thanks fo
sharing your knowledge
 
P

Pete_UK

Perhaps you could apply conditional formatting to the cells, such that
if the column you chose in the For each change of ... dialogue
contains "total" then change the colour. If you don't have a lot of
subtotals you could insert a blank line manually, but otherwise you
would need a macro to do that for you - search through that column and
if the cell above contains "total" then insert a blank row.

Hope this helps.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top