Making data validation dependent on other cell value?

Hi all,

I feel like this should be easy:

i want a dropdown-list with possible inputs for cell j35, the allowed inputs being: yes;no

But i want to prevent "yes" from being selected here IF c35 is set to "none".

The answers i've found seem to describe different tabs that i don't have within the data validation menu. I just have the tabs: settings, input message and error alert. And the option to select ''list'' from the ''allow'' drop-down menu is in the settings tab, and the source field is at the bottom of that tab as well. So i either select ''custom'' and can write a formula, or i select ''list'' and can write a list with options to be chosen from (yes;no) - but not both. Is there a solution to this? Or can i set the alert message to be dependent on the value of cell c35, so that at least i have a warning pop up when c35 is ''none'' and ''yes'' is being selected in j35?

thanks!

hey, thanks aliGW, unfortunately i cannot get it to work properly.

Since there are multiple options for c35, and only "none" (or rather: "geen") should disallow for "yes" (or rather: "ja") to be selected, i have changed the formula to this: =IF(C35<>"geen";J32;J33), with J32 and J33 being "ja" and "nee" (yes and no). But the remaining problem is that the menu only folds out completely and shows both "ja" and "nee" when C35 is set to "geen" and only then for only 1 use; meaning that only when i change c35 it shows the menu, and when i change j35 from "ja" to "nee" or the other way around, without changing c35, and then try to change j35 back again to "ja" or "nee", the option to do so is no longer there. The same happens when i change the formula to =IF(C35="geen";J32;J33), so it seems to be an issue with the mechanic of the system and not so much the formula itself, it seems ... Any clue what's going on here and how to fix it?

Here's the real example (cut out from the main sheet) of how im trying to implement it:

Lists AliGW2.xlsx

thanks in advance!

(ps i'll be gone for a couple of hours but will check in later today)