Conditional Format Archive

Change Excel’s default Subtotal format

Rabin Biswas | June 15, 2011

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.

Microsoft Excel

Highlight cells that contains Formula in Excel

Rabin Biswas | June 15, 2011

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