Disable a Drop Down...

[How_Do_I]

If a cell equals a certain value, (say A9 = 1) is there a way to disable a Data Validation Drop Down in another cell (say in A1) or, would I have to use Conditional Formatting to hide any data in A1 so hopeful users will not make a selection whilst A9 = 1… Any ideas please?

 

[GlennUK]

You can disable the drop-down by putting a formula in the List source definition ... but that would just stop the drop-down arrow doing anything, and wouldn't clear any current selection. You'd do Data Validation/List , source :

=IF(A9<>1,ListName,"")

Would that do?