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.