Tip Printed from ExcelTip.com

---

Applying colors to Subtotal rows according to the Subtotal level in Microsoft Excel


Two techniques:

• By changing Style.
• By Conditional Formatting.

Changing Styles

1. Insert Subtotals.
2. From the Data menu, select Group and Outline, Settings.
3. Click Apply Styles.
4. Select a cell at subtotal level From the Format menu, select Style.
5. For the style called RowLevel2, click Modify, change the style as desired, and click OK.
6. Use this technique to change the styles of all the subtotal levels.

Conditional Formatting
When you insert Subtotals, some cells remain empty in the rows containing the subtotals.

1. Select Cell A1, press Ctrl+*, and select the data table.
2. From the Format menu, select Conditional Formatting.
3. In the first argument, select Formula Is.
4. In the formula box, enter the formula =ISBLANK($D1).
5. Click Format, and select the desired formatting.
6. Click OK.
7. Repeat these steps for the second argument.
8. Click OK.