Two cells, using data validation | custom... COUNTA($A1:$B1)<2
This works fine to prevent data in both cells.
But I also want to use a drop down list for the data selection in A1 and B1,
How can I do both?
Thanks,
Keith