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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I want to make One Cell mandatory if another cell has a specific value , can anyone help me? 0
Excel Making a cell Mandatory 9
How to make an input in a cell mandatory without leaving it blank 3
Mandatory Input of a Cell 2
Cell Protection Query 15
Making Cell Entry Mandatory 4
ENTER skips unlocked cells 3
Date entry 1

Back
Top