View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
R Mills R Mills is offline
external usenet poster
 
Posts: 2
Default validation command

Nevermind that question, while i was typing the question I thought of copy paste and it does apear to work, but the custom formula for validation does not seem to be working, I want to warn unless a number between 1 & 60 is entered or the letter "N" entered. I tried - or(and(1,<60),<="n") -- but any number entry gives me the warning ?