Find out whether a cell has been typed or calculated

C J Squibb · #1 10-01-2013, 03:25 AM

I have a spreadsheet using VLOOKUP() to offer default values for certain cells. I would like to force this value to be typed manually, even if correct, so that if the lookup table value is later updated, previous entries remain unchanged. Is there a way I can identify the cells where the value has been derived from a formula, so that I can use conditional formatting to show these entries in grey?

Pecoflyer · #2 10-01-2013, 11:41 AM

Perhaps use following UDF

Code:

Function IsFormula(cell_ref As Range)
IsFormula = cell_ref.HasFormula
End Function

Place it in a general module.
=IsFormula(A1) will return True or False

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
the character "v" when typed acts like ctrl-v.	jim redfield	Word	1	09-22-2012 05:19 AM
Can I set AutoCorrect to work with inserted text (not typed)?	kyjac85	Word VBA	3	09-14-2012 08:19 PM
Inserting a date calculated from a table cell	theMikeD	Word	2	09-11-2012 05:46 PM
Text typed on slide x ports to slide y automatically?	Thinker	PowerPoint	5	07-26-2012 11:59 PM
Calculated dates.	Ziggy-R	Word	10	09-28-2010 01:42 AM