Thread: restricting entry into a cell based on entry to a previous cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default restricting entry into a cell based on entry to a previous cell
Use Data Validation

Data Validation... Custom Formula is:

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

apply this to F6, F7, F8
--
Gary''s Student - gsnu200790


"newbie57" wrote:

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?
Reply With QuoteReply With Quote