How do I restrict data entry to one of two columns but not both?
I have a spreadsheet with several columns that I will be asking colleagues to
fill with their data. Two of the columns are in date format and are an
either/or option. What I want to happen is that if someone inserts data into
a row in column A then they cannot insert data into the same row of column B,
or vice versa.
How would I do this?
|