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

"Max" wrote in message
...
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
--------------------------------------------
Give this expression a try:
=OR(AND(ISTEXT(A1),OR(A1="No",A1="Yes")),AND(ISNUM BER(A1),CELL("format",A1)="d4"))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"leimst" wrote in message
...
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