Data Validation, Custom
 

I have a spreadsheet where I am trying to limit a user's input in a
particular
cell to one of 3 options, "No", "Yes", or a date in a "MM/DD/YY" format.
Is this possilbe using the Data Validation function, choosing Allow:
Custom,
and inputing a formula?

Thanks!

Data Validation, Custom
 

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 have a spreadsheet where I am trying to limit a user's input in a
particular
cell to one of 3 options, "No", "Yes", or a date in a "MM/DD/YY" format.
Is this possilbe using the Data Validation function, choosing Allow:
Custom,
and inputing a formula?

Thanks!