Values dependant on previous values

[Mattymoo]

Hello

I need to build a spreadsheet which when a person selects a particular
option on one column than options dependant on that selection are given in
the next.

So for example if car colour blue us selected in column A, then black,
beige and blue are options for the interior in column B, but if red colour is
selected, then beige, red and green are displayed in then next column.

Help I'm new to complex formlas in excel (if this is complex!)

Thanks for looking

 

[Debra Dalgleish]

You can use dependent data validation lists. There are instructions here:

http://www.contextures.com/xlDataVal02.html

 

[OZDOC1050]

http://www.contextures.com/xlDataVal02.html

TRY THIS LINK
R
PETE