Validation Lists?

[war_amps]

I have made a drop down using the List in Validation with two options,
say X and Y. 95% of the time either X or Y will be chosen but I would
like to give the user the option to type into the same cell any value,
not necessarily X or Y. I could take out the Validation and let the
user input as a regular cell but I would like to keep the X,Y dropdown
if possible.

Any way to do this?

Thanks.

 

[Debra Dalgleish]

In the data validation dialog box, on the Error Alert tab, remove the
check mark from 'Show error alert after invalid data is entered'

 

[mangesh_yadav]

Oh yes, I forgot that.

Manges