Formatting a table with subtotals
 

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.