data validation - conditional

[tstanard]

I am using "list" for data validation so that the user can get a drop down list of values. I would like to have this in say column A and then in Column B, I would like to have another drop down data validation list that is dependent on the value that was selected in column A.
So if they select "green" for column A, Column B will only show the values: tree, grass, etc.
if they select "red" for column A, Column B will only show the values: Santa suit, cherry etc.
Is this possible or is there another way to do drop downs?

[Ron Coderre]

See Debra Dalgleish's coverage of Dependent Dropdowns:
http://www.contextures.com/xlDataVal13.html

Does that help?

[tstanard]

I'll give it a try...thank you!