Thanks to all three of you for responding to my question.
I now know how to answer the student's question and apply this information
in the future.
Thanks again!
Jugglertwo

"Dave Peterson" wrote:

I've found just putting up a warning in an adjacent cell is enough of a reminder
for most people.

=if(a1<"","","<-- Please fill in this cell!")



Jugglertwo wrote:

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

--

Dave Peterson