Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi,
I wanted to know if it is possible to make cells restricted based on values selected from a drop-down list? For instance let's assume that cell A10 has a list of 5 items. If item #1 is select then cells A2:A4 would be available for input, if item #2 was selected, then cells B3, B4 would be available for input. Can this be done? I know that it can be done via conditional formatting but I need more than 3 "limit" conditional format. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Order of selecting unprotected cells | Excel Discussion (Misc queries) | |||
trying to create an (almost) circular formula between cells and data validated cells with lists | Excel Worksheet Functions | |||
To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
making cells adjust | Excel Discussion (Misc queries) |