Formatting a table with subtotals

R

rabiddogg

Hi,

I just started using Excel 2007 and have a question

I have a worksheet that I use on a weekly basis. Basically it lists the
deposits for a 13 store franchise. Basically what I do is sort it by store,
then by date. Then I subtotal it by store then by date.

In previous versions of Excel, I could go to the automatic formating section
and pick one that would format it so that the subtotal rows are a different
color than the rows of data.

Please help.
 

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

Subtotal Formatting 2
Quick/efficient way to VBA subtotal 2
Recalculating Subtotals 2
Vlookup a subtotal 2
How can I subtotal then average the subtotals 0
Sorting Subtotals 11
% of subtotal in pivot table 1
Dealing with a Pivot Table (when I don't want to) 0

Top