| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
restricting entry into a cell based on entry to a previous cell
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? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fill a cell based on last entry | Excel Discussion (Misc queries) | |||
| Cell Entry That Locks Selected Cells From Any Data Entry. | Excel Worksheet Functions | |||
| Restricting entry in B1 on the basis of entry in A1 | Excel Worksheet Functions | |||
| Restricting entry in B1 on the basis of entry in A1 | Excel Worksheet Functions | |||
| Prevent entry based on another cell value | Excel Worksheet Functions | |||
Linear Mode
