Disable enable drop down based on another drop down

[Rahulwork]

Hello Everyone,

I have three drop down at

A1 B1 and C1

A1 has value, Apple, Boy and Cat

i want if A1 has apple, B1 drop down enable and C1 should disable
if A1 has Boy then B1 = disable and C1 = enable
if A1 has cat then B1 and C1 should enable

Please help.

 

[Dave87]

(XL2BB is blocked on my work laptop so sorry)

See attached images, is this what you are after?
Formula used in data validation box is =IF(G1="Apple",$B$1:$B$4,IF(G1="Boy",$C$1:$C$4,IF(G1="Cat",$B$1:$C4,"")))

There is a similar question asked @ Drop down list who's result is dependent on another drop down list