Data validation, list and custom in one cell

[Bobz1983]

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.

[Punnam]

hi,

Upload Sample workbook will be with out any confidential data showing after and before sheet u r requirement .

Punnam

[Bobz1983]

Here is a sample. I would like to restrict selection of drop down in cell C2, unless cell B2 is not blank.

Is data validation for allow list and custom possible?

[Punnam]

Hi,

Try this .

Punnam

[Bobz1983]

Awesome. So simple just didn't think of it. Thanks very much.