Hi guys,
Was wondering whether someone can help me with the below please.
For ease of reference I have attached a sample work file.
I have a list of deadlines - as can be seen in the worksheet called 'Information'.
Next, I have created a data validation list in the sheet called 'Input' whereby on can input any deadlines from the list found in the 'information' tab. Currently one can input an item from this list in Column B.
Would it be possible to include an IF statement in my data validation, so that the data validation list will only be selectable if in column C there is '1'.
Thus in the example attached Deadline 3 and Deadline 5 should not have the option to select the deadlines as column C is reading 0, not 1.
If possible, can someone please assist please?
Many thanks and appreciate all your kind help !!
Best regards
Keibri
Bookmarks