Hi,
I'd appreciate some help please with the below.
The idea is to have only ever one cell selected with "Yes", so that if the cell with "Yes" selected changes the previous cell with "Yes" becomes a "No"
I've attempted something like this below, but am struggling to change the old "Yes" to a "No"
Thanks for reading
PS appreciate the title is slightly misleading but fixing the old "Yes" to turn to "No" will mean the conditional formatting then fully works.
I'd appreciate some help please with the below.
The idea is to have only ever one cell selected with "Yes", so that if the cell with "Yes" selected changes the previous cell with "Yes" becomes a "No"
I've attempted something like this below, but am struggling to change the old "Yes" to a "No"
Toggle Test.xlsb
1drv.ms
Thanks for reading
PS appreciate the title is slightly misleading but fixing the old "Yes" to turn to "No" will mean the conditional formatting then fully works.