Since there is nothing to force the user to even select that cell, there is
nothing in Data Validation to prevent the cell from being left blank.
However, there are VBA methods that could be used. For instance, when the
user saves the workbook or closes the workbook, VBA can check that certain
cells are in whatever condition you want. If they are not, a message box
can be displayed to inform the user of what is required, and the
saving/closing can be negated if you wish. Post back if this might fit what
you want. HTH Otto
"carusso" wrote in message
...
Hi again all! ;-)

Is there a way to use the Data/Validation/List function to only allow
users
to only enter Y or N BUT cannot be left empty?

Or is there a Custom formula that will do this?

thanks!
--
carusso