Block access to data validation list if value in column A is blank

Hi all,

It's been a while since I was last on here.

I have a spreadsheet with a data validation list in cell B1. However, the drop down list should only be accessible if cell A1 is anything other than blank. If cell A1 is blank, then access to the drop down list must be restricted i.e. no values can be placed in cell B1.

Anyone know how to achieve this?

Regards

Try

with blank cell named "Blank"

in DV

LIst

source:

=IF(A1<>"",MyList,Blank)

Mylist is dropdown list

Thanks John. I knew you'd come up with a solution to this! Cheers, works perfectly.

Thanks Falcondude. Unfortunately I've only just got round to looking at my emails as since John's was the most recent reply, it was the email I saw at the top of my inbox. I'm sure this would have been a perfectly good solution, but John's works perfectly too.

You're welcome!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.