Change Excel’s default Subtotal format

The Subtotal function in MS Excel is one of the most used functions. But the default formatting of this function is not as good as the function is. Default function only Bolds the title but not the result. SO lets change it our won way.
To do this automatically we are going to use Conditional Formatting.

  • Click on Conditional Formatting >> New Rule… and Select Use a formula to determine which cell to format
  • Put this code there
    =RIGHT($A1,5)="Total"
    

    Change Excel's default Subtotal format

This formula needs absolute reference to the column and the row to work

And you have the Result
Conditional subtotal in Excel

Add a Comment

Your email address will not be published. Required fields are marked *

Notify me of followup comments via e-mail. You can also subscribe without commenting.