Highlight all formulas

In a sophisticated worksheet, we so often have to work extra careful in order not to accidentally messed up the worksheet, like replacing formula cells with static values. This is very troublesome and a pain-in-the-ass. Fortunately there is an easy way to highlight all cells that have formula so that we can easily identify which cells are calculated-cells.

Step 1

We start by selecting the entire sheet by pressing the entire sheet select button

Step 2

Then create a new conditional formatting (Alt + H, L, N) from the HOME menu.

Step 3

Then select "Use a formula to determine which cells to format", and enter the following formula into the rule box:
=ISFORMULA(A1)

Step 4

Press the Format button. This will open the Format Cells dialog.
Set the Font color to a color, here I choose purple. You can also set the Fill color so that formulas that return empty strings will also be visibly highlighted. Tips: To make the highlights look nice, set the Border color as well, like 10% grey.

Step 5

Press OK to apply and return to the Edit Formatting Rule dialog.
Press OK again to apply the formatting rule.

Now all cells that contain formula will be highlighted.

~Cheers