When using Data Validation with “List” chosen as the validation criteria, is Excel able to identify when duplicate values have been selected from a range and issue a warning or information message to the user?
I believe this may be accomplished when “Custom” is chosen as the validation criteria, however I would like to be able to have Excel issue a warning or information message when the user is restricted to a list.

Any ideas or help would be appreciated!