DATA VALIDATION ALLOW TEXT "DROP" and "check"

hi all,

i need some formula to data validation with this criteria :
allow only text "DROP" and "check" ...

could you help me, please!!!

thanks!!!

1. Highlight column or select cells in column you want the data validation list in.
2. Go to your Data tab and select "Data Validation"
3. Once in Data Validation, select list in first drop down menu and then in source window type DROP, check.

That should give you what I believe you are asking to accomplish.

thanks, but how can without list in but using custom then formula....

Sorry Jhon but I don't understand your question. Maybe post a sample workbook with an explanation and expected outcome.

i means some like ;
custom, formula then type formula =.......i don't know what this...
perhaps, are there another/new ideas without validation list in???