ExcelBanter - Need help with validation formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Need help with validation formula - URGENT! (https://www.excelbanter.com/excel-discussion-misc-queries/160323-need-help-validation-formula-urgent.html)

Courtneyf04

Need help with validation formula - URGENT!

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

Need help with validation formula - URGENT!

One way:

Data/Validation/Settings:

Allow: List
Source: Y,N

In article ,
Courtneyf04 wrote:

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!

All times are GMT +1. The time now is 12:47 PM.