MrExcel Publishing
Your One Stop for Excel Tips & Solutions

indicating which cells have formulas

Posted by Patrick Node on December 18, 2001 11:40 AM

Is there a quick and easy way to format cells to indicate which ones have formulas and which have values? I know you can display all formulas, but
I want to look at the spreadsheet and easily tell
which are calculated values and which are entered

Thanks -


Posted by Juan Pablo G. on December 18, 2001 11:50 AM

One *quick* method to do this is as follows.

Select A1.
Go to Insert, Names, Define.
Put a name in it, like HasForm
in the refers to put:

Now, select the range you wanna "check" for formulas. Select Conditional Formatting, change Value is to Formula is, and put this formula


Click on the pattern button and select something that makes it easy for you to see it has a formula and you're ready to go !!

Juan Pablo G.

Posted by Mark W. on December 18, 2001 1:48 PM

Select the cells of interest (or all cells on the
worksheet), choose the Edit | Go To... | Special...
menu command, and click on either the Constants
or Formulas radio button, and press [ OK ]. Cells
conforming to the chosen option will be highlighted.

Posted by Patrick on December 18, 2001 3:18 PM


Posted by Patrick on December 18, 2001 3:20 PM

Thanks, Juan.