data validation

  • Thread starter Thread starter sue
  • Start date Start date
Sue,

In the Allow list, choose Custom, and enter the following formula:

=OR(A1="yes",A1="no")

Change A1 to the appropriate cell.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
Sue,

When you get into the data validation form under the Settings
Tab choose List for the Allow type. Then in the Source field
type "Yes, No" (without the quotes). Uncheck the In-Cell
Dropdown field and hit OK (or leave it checked if you wan't to
let the user select).

Dan E
 
Back
Top