![]() |
|
#1
|
|||
|
|||
|
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? |
| Tags |
| conditional formatting, formulas, vlookup |
| Thread Tools | |
| Display Modes | |
|
|
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 |