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.


Step 1

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


Step 2

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


Step 3

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


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.


Hope this helped.

Share The Knowledge

Random Posts

Leave a Reply