View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gillian Gillian is offline
external usenet poster
 
Posts: 14
Default 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?