Case Sensitive Data Validation

Hi

If I have data validation on a cell with a specific list of values or looking at a range it is still possible for a user to enter something that is in the list but a different case. Is it possible to restrict the case of an entry to the same as the one defined?

Thanks
Ben

Hi,

Instead of using a named range, you would have to type your list in
the data validation dialog box.

HTH
Carim