Data Validation, Custom
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! |
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 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! |
All times are GMT +1. The time now is 11:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com