Making cells "unavailable"

T

TC

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
 
T

TC

Gary,

thanks, I actually found a way to do it. I used the VLookup function on
the individual cells. So now if the user selects a certain product, only the
designated fields will appear on the form. Works like a charm.
 
Top