stop a clicked on cell being left blank

[Guest]

I want to stop a cell in excel being left blank once user has clicked on the
cell.

I have a column that has to have a Y or N response. There is data
validation on the cell sop only Y or N can be entered. Nowever once the user
clicks on this cell i want them to HAVE to enter either the Y or N value. At
the moment if they leave it blank it accepts this as a reponse. I would like
it to force them to enter a Y or N before they can continue!

 

[Guest]

Clear the check next to "Ignore blank" in data vaiidation dialog

 

[Guest]

I tried this - it still accepts a blank value. I have tried it both with the
ignore blank cell ticked and unticked.

Tried saving, cosing reopening no luck. Tried rebooting no luck - so tried
it at home on a completely different PC last night - still wouldnt work.

Any more ideas.

(i have it set to STOP)