On the Home tab, click the Conditional Formatting dropdown (Styles group) and choose New Rule. In the resulting dialog, click the Use a Formula to Determine Which Cells to Format option.

Click the Data tab and then click Subtotal in the Outline group. In Excel 2003, ... that’s the key to displaying different subtotaling functions for the same groups.