View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Greyling Greyling is offline
external usenet poster
 
Posts: 3
Default multiple data validation criteria

I have to restrict the number of characters in a cell that already has a data
validation criteria of selecting from a named range. How do I apply the
second criteria of saying that this selection now must be equal to 30
characters (I need to export to a text file that requires specific character
lengths for each data element gathered).