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?