Hi Dave,
Have a problem on this. I have many columns of different names and don't
have an adjacent cell to put your formula to pop up. Also, I want to prevent
them from saving the worksheet unless all the required cells are filled up
with values like we have in Internet online form. Is it related to a macro?

"Dave Peterson" wrote:

I use an adjacent cell with a formula like:

=if(a1<"","","Please enter something in A1")

And I format it as big bold red letters.

Sandy wrote:

How to make an input in a cell mandatory without leaving it blank like we
have for any online form where name field is mandatory or else form wouldn't
be saved.

--

Dave Peterson