In the formula box, enter the following formula: =ISNUMBER(FIND("Total",$A1)).In the Select a Rule Type area at the top of the dialog box, choose Use a Formula to Determine Which Cells to Format.Excel again displays the New Formatting Rule dialog box. The rule you just created now appears in the Conditional Formatting Rules Manager dialog box.
![can you add multiple subtotals in excel can you add multiple subtotals in excel](https://www.customguide.com/images/lessons/excel-2019/excel-2019--outline-and-subtotal--04.png)
![can you add multiple subtotals in excel can you add multiple subtotals in excel](https://www.lifewire.com/thmb/R2lA1qF8meoMbf3nrkCWvl88zew=/768x0/filters:no_upscale():max_bytes(150000):strip_icc()/2018-02-25_15-27-43-5a932c88ff1b7800370375cd.jpg)
Make sure the Home tab of the ribbon is displayed.Before applying your subtotals, select your entire data table.If you will be repeatedly adding and removing subtotals to the same data table, you may be interested in using conditional formatting to apply the desired subtotal formatting. Now, only the visible subtotal rows are selected. Select the Visible Cells Only option button.Click Special to display the Go To Special dialog box.Press F5 to display the Go To dialog box.
![can you add multiple subtotals in excel can you add multiple subtotals in excel](https://www.solver.com/sites/default/files/panelmanufacturingsolver1.jpg)
Using the Outline area at the left of the screen, collapse the detail in your worksheet so that only the subtotals are showing.Select the entire data table, including the subtotals.If you use subtotals sparingly, and only want to apply a different format for one or two worksheets, you can follow these general steps: You, however, may want to have some different type of formatting for the subtotals, such as shading them in yellow or a different color. When you add subtotals to a worksheet, Excel automatically formats the subtotals using a bold font.