Highlight Cells With Formula In Excel

Let’s see how to highlight all the cells in a sheet in excel that contains formula.

We are often come across a situation where we modify the data in a sheet in a table, however we have to make sure that the cells with formula are not modified, so it a good exercise to highlight the cells with formula with some color formatting so that those are not changed mistakenly.

We will see an easy example as to how to highlight the cells with formula in excel.

Below is the sample data in which we want to highlight the cells with formula.




Capture

Step 1

Select the data part in the table and press keyboard shortcut Ctrl+G to open the Go to option in excel.

Capture

Step 2

Click on “Special” option at the bottom left corner and select the Formula, press OK.

Capture

Step 3

It will show you all the cells in your selection with formula.

Capture

Step 4




Now format them as you wish, you could color them with some different color to distinguish them from rest of the cells.

I have made them grey.

Capture

Hope this helped.

Share The Knowledge

Random Posts

Leave a Reply