How to use List based on other list

[manish.agrawal446@gmail.com]

Hi,
Greetings...
I have the following data with me (sample, unfortunately I can't upload)
A1- has a list (Fruits, vegetables, animals)
a2 - list will be displayed based on selection in A1... for eg if i select Fruit in A1, it will display only apple, orange and so on
a3. List should be displayed based on A2... incase i select apple, it will display red.

Can we do without macro...

apple, green apple and so on...
Thanks & regards,
Manish

 

[Somendra Misra]

Hi Manish,

This query has been answered many a times on this forum. If you use search feature on the right top you can go through the various threads.

Go through this link.
http://www.contextures.com/xlDataVal02.html

Regards,

 

[NARAYANK991]

Hi Manish ,

Check out these links :

http://www.myonlinetraininghub.com/excel-factor-19-dynamic-dependent-data-validation

http://excelsemipro.com/2011/05/a-dynamic-dependent-drop-down-list-in-excel/

http://www.excelsage.org/how-to-use-dynamic-data-validation-in-excel-in-a-clever-way/

Narayan