View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
a-one-and-a-two a-one-and-a-two is offline
external usenet poster
 
Posts: 5
Default How do I get data validation to disallow specific entries

Hi,
This may be obvious, but not to me...
I want to prevent a few specific words from being entered in a column, but
except for these exclusions, anything goes. I have only been able to figure
out how I can ALLOW certain entries in a list, but this is kind of the
reverse situation. Any ideas?