Question: what is the formula for yes or no in excel?
Answer: Then in the Data Validation dialog, under Setting tab, select Custom from the Allow drop down list, and type this formula =(OR(A1="Yes",A1="No")) into the Formula textbox.