restricting entry into a cell based on entry to a previous cell

  • Thread starter Thread starter newbie57
  • Start date Start date
N

newbie57

I have a group of cells for an inventory sheet. I want to prevent double or
incorrect entry. For example, if there is any entry into cell F6 they cannot
place an entry into F7 or F8. The same would apply for entry into F7 which
would restrict entry to F8 and F6. Can this be done?
 
Use Data Validation

Data > Validation... > Custom > Formula is:

=COUNTA($F$6:$F$8)=1

apply this to F6, F7, F8
 
Back
Top