How to determine if a cell contains a value or a formula?

G

George

I have data that goes from projections to actuals. I would like to identify
either through a formula or conditional formatting whether a contains a
formula or has been over written with a value.
 
K

Kevin B

Select all the cell you want to examine and press F5.

Click the SPECIAL command button in the lower-left hand corner of the dialog
box, and then click the FORMULAS option button and click OK. Only cell
w/formulas will be selected.

You could then format those selected cells with a shaded interior or
something...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change the colour of a neighbouring cell 6
Function to determine if a cell contains a formula 5
Determine if previous "character" is a section break 3
Word VBA - Want to test if Full Name is NOT Present in document 0
Drop down list control value in vba 2
Formula to Determine if Cell Value is from a Keyed Value or a Form 2
Use TODAY() function as the criteria in a SUMIF formula 1
Conditional formatting based on formula cell 4

Top