If function and Combo Box

Hello,
I am having an issue trying to figure out how to create an if function within a Combo Box. Here is what I am trying to do:
If my ComboBox1 (column A) is showing value "colors" I would like my other ComboBox2 (column B) to take values from column C. If my ComboBox 1 is showing anything else other than "colors" then I would like my ComboBox2 to pull values from column D.

Any ideas?

Sounds like you'd have to use a macro for this and more than likely trigger it when a value in column A changes. Have any experience working with vba?

This can be done with VBA code. You may want to check an example of using VBA code to work with the ComboBox control. If you haven't learnt VBA for excel before, i recommend you to learn it.
http://www.worldbestlearningcenter.c...ta-example.htm

Thank you! I don't have any experience with vba but I will try to look into it.