Changing data validation source values does not update cells using the original value

Question

I have Sheet1 with an in-cell dropdown select box. The values in the drop-down come from the values in a different range (i.e. on Sheet2)

What I need now is to update the value in any cells with data validation in Sheet1 if I change those values in Sheet2. Currently, if I update values in my validation range (Sheet2), the cells using the old value in Sheet1 show a warning:

How to mass update past rows with updated range in Sheet2?

UPDATE:

In other words:

I change a value in my data validation's criteria range, but previously added rows that already selected that value - which was valid at that time - still have the old value. Viewing the drop-down range then flags these previous settings as invalid. Can I somehow update any cells that used the old data validation value to use the new value?

Answer 1

Set the lookup range of the data validation to the whole column instead of a specific range, e.g. A:A or A2:A instead of A2:A10, then you won't have to update the range in the data validation formulas.