Blocking data entry

J

JP

Is it possible to configure a cell or cells to be unavailable for data entry
unless data is entered in another cell or cells first?
 
C

Chip Pearson

You can do this with Data Validation. Select the cell whose entry you
want to restrict. Open Data Validation dialog from the Data menu,
choose "Custom" on the Allow list, and enter

=LEN($D$1)>0

where $D$1 is the cell which must have data in it in order to enter
data in to the validated cell.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional,
Excel, 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
 

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

Lock out data entry in a cell 1
Populate cell with data from another worksheet 4
Data Entry Cells 2
#VALUE! ERROR 3
How To Have A Cell Be Blank If... 2
Data validation 3
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Conditional locking of a cell 2

Top