Thread: Data Validation
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
k1ngr k1ngr is offline
external usenet poster
 
Posts: 15
Default Data Validation

How can I do Data Entry Validation for all the cells in a column.

I want to make sure all entries a
1. Exactly two characters long.
2. Are all upper case.
3. Are only alpha-characters.
4. Are not duplicated (no two cells contain the same sequence of two
characters).

Dick King