Hi,
My data validation list only has 1 entry = "YES"
Is it possible to only allow 1 selection from a data validation list that covers 3 cells?
So for example:
if I had cells A1:A3 with the list in and I selected A1 to have the "YES" is it possible then to have the validation list empty for cells A2:A3 and then if "YES" was deleted from cell A1, it would then become available to all 3 cells again.
I hope this kind of makes sense and I really appreciated the help.
Thanks
Dan
My data validation list only has 1 entry = "YES"
Is it possible to only allow 1 selection from a data validation list that covers 3 cells?
So for example:
if I had cells A1:A3 with the list in and I selected A1 to have the "YES" is it possible then to have the validation list empty for cells A2:A3 and then if "YES" was deleted from cell A1, it would then become available to all 3 cells again.
I hope this kind of makes sense and I really appreciated the help.
Thanks
Dan