A student asked this question recently and I couldn't figure it out.
We were doing data validation and they asked if there is a way to require
that a cell have information entered in it and it can't be left blank.
I tried several options but couldn't get it to work.
Any suggestions using data validation and/or any other Excel features?
Thanks for any suggestions!
Jugglertwo