| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Entry That Locks Selected Cells From Any Data Entry.
Say the list is 7 columns wide. If I put "A" in B2, I want to be able to
input data in C2 thru G2. But, if I put "B" or "P" in B2, I want cells C2, E2 and F2 to allow no data to be entered. If the B2 entry is changed to "A", all cells C2 thru G2 become available for entry again. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| fill all cells in row with one cell entry | New Users to Excel | |||
| How do I compare the entry in one cell against all other cells | Excel Discussion (Misc queries) | |||
| Validate MsgBox Entry to Data in Cells | Excel Discussion (Misc queries) | |||
| data entry from two cells across worksheets | Excel Discussion (Misc queries) | |||
| Selected cells grow and data entry impossible EXT is dissabled | Excel Discussion (Misc queries) | |||
Threaded Mode
