Requiring a user to give a response with VBA and Data Validation

[dunhamsasphalt]

I have a data validation set in 3 columns so that the answers will remain consistent, and I don’t want this to change. I want cell D to be required if cell B has an answer selected (which will always be “Yes” because of my data validation restriction). But I don’t want cell D to be required if cell C has “No” entered into it. I already have a VBA setup that only allows the user to select either “Yes” in column B, or “No” in column C, so that they won’t try to select yes and no on the same row.

How can I require that cell D be answered (using my data validation list that is already assigned to column D) but only require it if the user has selected “Yes” in column B? I hope this makes sense. I absolutely cannot find an answer for how to do this anywhere online and everything I try gets me close but doesn’t do exactly what I am wanting.



In short (I've attached a picture for reference):

They can only select “Yes” from my data validation list in column B, or they can only select “No” from my data validation list in column C. They cannot select yes and no on the same row because I have a VBA in place to prevent that already.

In column D, the data validation is a rating # list (1 thru 5) because I don’t want them to use any other numbers than 1 thru 5 or accidentally put a letter and muck everything up (because they will absolutely do that if they have the option). All of my data validation lists are required in my situation.

So, I only want cell D to be required if “Yes” has been selected in column B. I want this for every Row starting from Row 18 all the way to row 160. Please say someone knows how to make this happen. Thanks.