When an option is selected from list, it should force the user to enter data elsewhere

Hi,

I have a dropdown list with 5 options in it.
1. reject
2. accept
3. scrap
4. missing
5. other

when the user selects option 5 (other), I want excel to force the user to enter the (other reason) in the next column.

NOTE: this is only for option 5 and not for any other options.

Thanks

thank you very much, work really well.

i was wondering how i could make this work for entire A and B column? (note just A1 and B1)

Thanks

yes, the drop down list in on the entire A column and I need other reason added on the B column (if it was selected).

Thanks

this problem has been solved on the below thread.

http://www.excelforum.com/showthread...t=#post4471353