View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Mike Josephson Mike Josephson is offline
external usenet poster
 
Posts: 3
Default Validating a Not Equal To Condition

Given a column that is named "Type" (G1:G50), I tried to enter a validation
rule that does not allow "ULT" to be entered, I tried <"ULT" but that
doesn't work also tried
=if(g1<"ULT","") and that doesn't work. I would ultimately like to have 5
phrases that would not be allowed. Am I restricted to using VBA? I'm just
trying to find the easiest way without alot of code. Any help would be
appreciated....

Thanks
Ambassador