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
values.

Thanks -

Pat


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:
=GET.CELL(48,A1)

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

=HasForm

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

Thanks!!

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

Thanks, Juan.