Variable Data Validation?

[GaryB]

We have a spreadsheet with a dropdown that only allows "Yes" or "No" in column D
A user now want to change this so that if cells Ax Bx or Cx are "ABC", "DEF" or "GHI" then Dx should only have the "No" option. I've not been playing with Excel as much of late and am very rusty, but I have a sneaking suspicion that he is asking to much, but I'd be delighted if someone would prove me wrong!

Thanks for your time.
GaryB

 

[Peter_SSs]

See if this is any use.

I have named the range F1:F2 as YesNo
I have named the range F2 as No

Data Validation in D3 as shown.

Excel Workbook
	D	E	F
1			Yes
2			No
3
4
Variable DV

#VALUE!

</td></tr></table></td></tr></table>

 

[GaryB]

Sir, you are a gentleman and a scholar!
Perfect- thanks very much

GaryB