How do I make a specific cell mandatory?
 

Can a specific cell be locked and made mandatory entry to "unlock" entry into
other cells? It will be the first piece of information entered into a
spreadsheet and can't be skipped.

How do I make a specific cell mandatory?
 

Lets say the cell A1 must have something in it before you can put anything in
B1. Select cell B1 and then from the Data menu select Validation - Custom -
Formula =A1<"". Uncheck Ignore Blanks and then hit OK.

You now can not enter anything in B1 until A1 has a value in it. You will
probably want to change the message to the user explaining that A1 is
mandatory.
--
HTH...

Jim Thomlinson


"soday" wrote:

Can a specific cell be locked and made mandatory entry to "unlock" entry into
other cells? It will be the first piece of information entered into a
spreadsheet and can't be skipped.

How do I make a specific cell mandatory?
 

Lets say the cell A1 must have something in it before you can put anything in
B1. Select cell B1 and then from the Data menu select Validation - Custom -
Formula =A1<"". Uncheck Ignore Blanks and then hit OK.

You now can not enter anything in B1 until A1 has a value in it. You will
probably want to change the message to the user explaining that A1 is
mandatory.
--
HTH...

Jim Thomlinson


"soday" wrote:

Can a specific cell be locked and made mandatory entry to "unlock" entry into
other cells? It will be the first piece of information entered into a
spreadsheet and can't be skipped.