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
--
Greetings from New Zealand
Bill K



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