Excel offers no such constraint. If someone is determined to enter bad data, they can simply paste values over a validated ...
I'll walk you through two methods for handling this essential task, plus a third way that achieves total annihilation.