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!
|