|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 21st, 2010, 06:05 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
Mandatory/Compulsory
Hi Sir,
I need to put a formula for a cell as mandatory/compulsory it has to fill, otherwise it will not go to the next cell. It has to display (customized) error message. Can anybody help me in this regard? I have Office 2000, 2003 & 2007. It has to work in all versions. Rgds, Md.Siddique. 
|
|
#2
April 21st, 2010, 06:31 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Mandatory/Compulsory
EXCEL 2007
Data / Data Tools group / Data Validation / in here there are various options available to you including custom messages. If my comments have helped please hit Yes. Thanks. "Md.Siddique" wrote: Hi Sir, I need to put a formula for a cell as mandatory/compulsory it has to fill, otherwise it will not go to the next cell. It has to display (customized) error message. Can anybody help me in this regard? I have Office 2000, 2003 & 2007. It has to work in all versions. Rgds, Md.Siddique.
|
|
#3
April 21st, 2010, 01:02 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Mandatory/Compulsory
This won't stop the user from selecting a different cell, but I'd use a formula
in an adjacent cell. =if(a1"","","-- Please enter something into this cell!") I'd give it a big red format so that it's easy to see. Md.Siddique wrote: Hi Sir, I need to put a formula for a cell as mandatory/compulsory it has to fill, otherwise it will not go to the next cell. It has to display (customized) error message. Can anybody help me in this regard? I have Office 2000, 2003 & 2007. It has to work in all versions. Rgds, Md.Siddique. -- Dave Peterson
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
