Uncheck "Ignore blanks" in the validation dialog

Initially the cell can be blank, but once filled it cannot be blanked again.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Tetsuya Oguma" wrote in message
...
| 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