"Custom" Data Validation

  • Thread starter Thread starter leimst
  • Start date Start date
L

leimst

I want to be able to control a user's input to a couple of test words such
as "Yes" or "No" or a date. One of those 3 options and of course the dates
input would vary. Is this possible?

Thanks in advance
 
Try this:

=OR(A1="Yes",A1="No",ISNUMBER(A1))

Note that a date is really just a number formatted to look like a date. So,
using the above a user could enter a 0 and it will be accepted. You could
refine the date requirement by allowing a range of dates and eliminate the 0
scenario. For example, allow dates from 1/1/2005 to 12/31/2010:

=OR(A1="Yes",A1="No",AND(A1>=DATE(2005,1,1),A1<=DATE(2010,12,31)))
 
Your multi-posting is terrible. The way to engage is to discuss things in
the same thread, not to keep flinging the same question several times. If
what I posted in response didn't work/doesn't appeal to you, just reply to
me in the thread. Other responders could always step in with other stuff for
you

Posted this response a couple of days ago
 
That worked great! I didn't know how to handle the date restriction so
thank you so much for the help!

Brian
 
I apologize for multi-posting but did not realize that I was doing that. As
a matter of fact, I have been trying to post that question since 6/8 and for
some reason I was never able to see my posting or any responses until today!
I never saw the response you provided.

Thanks for the heads up and I'll try to figure out what I might be doing
wrong!

Brian
 
Back
Top