Restrict the selection to only one cell

Completed Posted 5 years ago Paid on delivery
Completed Paid on delivery

I have multiple cells with drop down list with "Yes" or "No" value where I would like the sales people to change the value to yes to any of the cells but only one cells can have the value of yes.

Excel

Project ID: #17448275

About the project

3 proposals Remote project Active 5 years ago

Awarded to:

$30 USD in 1 day
(70 Reviews)
5.7

3 freelancers are bidding on average $30 for this job

Khurramz

Hi Is the file used independently by each user? .

$30 USD in 1 day
(372 Reviews)
7.5