D dchatrie New Member Dec 12, 2012 #1 I would like a formula that if say A1=1 you cant type in B1 and C1. As well as if B1=1 then A1 and C1 you cant type in and if C1=1 then A1 and B1 you cant type in. Something like mutually exclusive.
I would like a formula that if say A1=1 you cant type in B1 and C1. As well as if B1=1 then A1 and C1 you cant type in and if C1=1 then A1 and B1 you cant type in. Something like mutually exclusive.
Luke M Excel Ninja Staff member Dec 12, 2012 #2 Select cells A1:C1. Data - data Validation. Custom rule. =COUNTIF($A$1:$C$1,1)=0 hit 'ok'. You should be all set now.
Select cells A1:C1. Data - data Validation. Custom rule. =COUNTIF($A$1:$C$1,1)=0 hit 'ok'. You should be all set now.
