IMHO, VBA is the only way to accomplish this.

--
Gary Brown

"TC" wrote:

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