Lock out data entry in a cell

D

DShaver

I need to lock out data entry in a cell based on whether text (from a data
validation list) is entered in another cell.

I have a column labeled Amount. I want to lock each cell and only allow
data to be entered if the cell above it has an amount entered. The first
cell will be open for data entry. I'm doing this so a user has to go through
a form sequentially line by line and can't skip a line.
 
D

DShaver

Clarification - the first cell will be locked and only allow data to be
entered if a value from a drop down list is selected in a cell above. Each
cell below the first cell is dependent on whether a value is entered in the
cell above it.
 

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

Top