prevent data in cell if data in another

  • Thread starter Thread starter Keith
  • Start date Start date
K

Keith

Column A and Column B have data validation to allow a selection from a list.
Basically the list is just a checkmark.
Column A is YES
Column B is NO

How can I prevent a cell in column A to have data entered if column B
already has data. In other words the user has to be prevented from entering
data in both A1 and B1

Thanks,
Keith
 
Keith,

Select columns A and B, and use Data | Validatation, then under Allow select
"Custom", and use the formula

=COUNTA($A1:$B1)<2

HTH,
Bernie
MS Excel MVP
 
Bernie,
That works for preventing data in two cells but I lose the drop down list.
How can I do both?
Thanks,
Keith
 
Back
Top