stop a clicked on cell being left blank
 

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!

stop a clicked on cell being left blank
 

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

"Nicole Answer" wrote:

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!

stop a clicked on cell being left blank
 

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)

"Tevuna" wrote:

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

"Nicole Answer" wrote:

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!