View Single Post
 
Old 10-01-2013, 03:25 AM
C J Squibb C J Squibb is offline Windows 7 64bit Office 2010 32bit
Novice
 
Join Date: Aug 2013
Location: Essex
Posts: 14
C J Squibb is on a distinguished road
Question Find out whether a cell has been typed or calculated

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?
Reply With Quote