Select the cell (say,A1):
Data Validation
Allow:
select Custom
Formula:
=(OR(A1="Y",A1="N"))

"NickR2" wrote in message
...
We need to format a cell so that it will only accept a "Y" for yes, or a
"N"
for no.
How can this be done?

Thank you