Forced Cell Input in Excel 2002
I'm working on a spreadsheet that is shared by dozens of users, but the data
input is reviewed by a few of us. To make our trip through the data quicker,
I'm looking for a way to generate an error if they do not fill in certain
fields in the document. Some of the fields are optional, but some should be
mandatory. How do I force them to fill out those fields or get an error
message?
Thanks
|