I'm working on an excel sheet and I have added Yes/No data validation drop downs. I would like to add a formula that will control the outcome of other cells when one cell is selected. For example, if I select Yes for working, I would like the other cells to revert to No. If I selected Yes for Scheduled off, all other cells should be No. The same for all other columns
[TABLE="class: grid, width: 500"]
[tr][td]Working
[/td][td]Scheduled off
[/td][td]Vacation
[/td][td]Called Out
[/td][td]Training
[/td][/tr][tr][td]Yes
[/td][td]Yes
[/td][td]Yes
[/td][td]Yes
[/td][td]Yes
[/td][/tr]
[/TABLE]