Conditional Format Archive
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.
This hack is very useful if you often need to change or check your formulas in your worksheet. To achieve the goal we will use Excel’s conditional formatting