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?
|