excel do not allow values in 2 cells?

A

audi owner

New member
How can I use data validation or alerts to not allow values in 2 cells ?
Example: either A2 or B2 must have a value, but not both. same for A3 and B3, etc.
If one field contains a value, then the other field must be blank.

Thanks
 
Back
Top