Data Validation

L

leimst

I have a spreadsheet that I have been working on 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!
 
M

Max

Give this expression a try:
=OR(AND(ISTEXT(A1),OR(A1="No",A1="Yes")),AND(ISNUMBER(A1),CELL("format",A1)="d4"))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Validation, Custom 1
Data Validation, Custom 1
Date Format 10
VBA - exporting serial letters to single documents 0
VLOOKUP & Data Validation 0
custom data validation on cells with data validation values 2
Data Validation Date Format 2
How to enter a date in DD-MM-YYYY format 2

Top