ExcelBanter - manadatory data entry cells in excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - manadatory data entry cells in excel (https://www.excelbanter.com/excel-worksheet-functions/206212-manadatory-data-entry-cells-excel.html)

Neale

manadatory data entry cells in excel

How do I make cells mandatory for a user to enter information and if the cell
is left blank the user should be prompted with a warning of the invalid entry

Satyendra_Haldaur[_2_]

manadatory data entry cells in excel

Validation can work for you.go to DATAValidation in excel 2003. you can even
give your own error message. but validation has its limit.

"Neale" wrote:

How do I make cells mandatory for a user to enter information and if the cell
is left blank the user should be prompted with a warning of the invalid entry

All times are GMT +1. The time now is 11:52 AM.