Excel offers no such constraint. If someone is determined to enter bad data, they can simply paste values over a validated range or open the file in another program to completely bypass the rules I ...