cell should not be blank
 

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

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?

Krish,

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

Jack Sons
The Netherlands

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

Oops, I mean "in the data menu".

Jack.

"Jack Sons" schreef in bericht
...
Krish,

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

Jack Sons
The Netherlands

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