ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Mandatory/Compulsory (https://www.excelbanter.com/excel-discussion-misc-queries/262028-mandatory-compulsory.html)

Md.Siddique

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.


trip_to_tokyo[_3_]

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.



All times are GMT +1. The time now is 12:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com