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

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?
 
G

Gary''s Student

Use Data Validation

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

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

apply this to F6, F7, F8
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting an entry to a cell 2
Color Coding cell based on date (over a large range) 3
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
how to make excel record cell entry dates 5
last entry in a range? 2
Cell Entry Dependent on Option Control 2
display last entry into a cell automatically 2
How to format cells for uppercase entry 3

Top