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