Hi all,

I have got a Named range including two cells, including "Y" and "N" in each
cell. Then, I link that up with Data Validaiton List pointing to the Range.

This yet still allows users to enter blank cell and get away with it...

Q: How can I prevent users from entering blank?

Thanks in advance.

Tetsuya Oguma