How do I make a specific cell mandatory?

  • Thread starter Thread starter soday
  • Start date Start date
S

soday

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.
 
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.
 
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.
 
Back
Top