force validation

[apgmin]

Hello All,
Can anyone please help me with this problem.

In cell M2:M151, the user needs to select a value from a list ( R2:R18) which I have made through data validation feature

Now the user many times does not select any value and keeps the cell vacant ( Note cells R12:R18 are vacant at present )

Can I force the user to select any value from R2:R18 but not keep the cell M2 vacant before he fills cell M3 in the next row

 

[DRSteele]

I suspect you cannot do that. Perhaps someone can write some VBA code to force the cell to contain something from the List, but you cannot coerce a cell dictated by a DV operation to be non-blank.