Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Empty Cell ( blank Cell ) | Excel Worksheet Functions | |||
up to 7 functions? | Excel Worksheet Functions | |||
Look for change next blank cell in Range | Excel Worksheet Functions | |||
Go to first blank cell | Excel Worksheet Functions |