How do I make a specific cell mandatory?

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.
 
J

Jim Thomlinson

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.
 
J

Jim Thomlinson

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
Making Cell Entry Mandatory 4
Mandatory Input of a Cell 2
How to make an input in a cell mandatory without leaving it blank 3
VB Coding 1
Conditional mandatory fielld ? 0
How do I insert a photo into a specific cell? 3

Top