Data validation or conditional formatting

[The Grim Discovery]

Peoples

Please help.

Here's my situation. Cell D35 will contain either 'true' or 'false' depending on if the checkbox in D14 is ticked or not.

When D35 = "false" I want cells D20:D24 to be locked/uneditable.
When D35 = "true" I want to be able to enter either 'yes' or 'no' into each of cells D20:D24 - preferably by using a drop down menu in each.

I've been reading about getting dependent lists functioning for a similar(ish) but cant get this to work and I'm now not clear if this is about data validation or conditional formatting. Or something else.

Thanks so much.

 

[Gerald Higgins]

Hi, you can do this with Data Validation.

Apply this Data Validation to D20 . . .

On the Data Validation dialog box
Setting tab
Allow: CUSTOM
Formula
=AND(D35=TRUE,OR(D20="YES",D20="NO"))

 

[The Grim Discovery]

Hi Gerald

Thanks for your support (not for the first time).
I've done as you've suggested but there's nothing happening. If you've any other ideas I'd be grateful

 

[Gerald Higgins]

Hi, how do you mean there's nothing happening ?

What SHOULD be happening is that IF D35 contains TRUE, then you should only be able to input YES or NO into D20.

It might not give you a drop down box, but it should prevent you inputing anything else.