cell should not be blank

K

Krish

If I dont enter any value in the cell, then it should give a message saying
"Please enter Value". How to do this?
 
B

Bill Kuunders

To have the message come up in A1

Enter in B1
=IF(A1="","Please enter value ","")
Right align B1 and you may need to change the number of spaces in the
message
or the width of column B

Protect B1
 
J

Jack Sons

Krish,

Perhaps is validation a useful instrument? (in the tools menu)

Jack Sons
The Netherlands
 
Top