Hi Im trying to create a IF condition where in a dropdown list if "Yes" is selected, the No is selected in two anther dropdown lists.

The content of the dropdown list is coming from a lookup sheet. I'm getting error messages that the content is restricted but the Source is a selection within the lookup sheet. I wish I could post a picture but here the details:

Data Validation criteria is a List: "Yes", "No", "NA."

I have three locations with this data validation criteria that I would like to set a condition that if one of these locations is equal to "Yes" the other two location are equal to "No."

I was trying to do this in Conditional Formatting but any help would be great.

Thanks