Hi,

I have created a drop list in a cell but would like to restrict entry if another cell is blank. So at the same time, I would like to have a drop list and a custom validation that will stop the user choose from the list because they have not populated another cell.

Overall, I would like to ensure sequential data entry rather than skipping cells.

Can anyone help?

Thanks.