Need help with validation formula - URGENT!

[Courtneyf04]

I need to have one column set up so that all that can be entered into it is
either a capital Y or capital N. I appreciate the help. Working in Excel
2007. Thanks!

 

[JE McGimpsey]

One way:

Data/Validation/Settings:

Allow: List
Source: Y,N