Limiting the options a user can select

New Contributor

I am building a worksheet where users can build a product. Right now I have different data validations for those options. If I wanted a user to be able to select one option and not be able to select another option how would i go about doing this in excel? For Example a customer picked a red color t but cant select a certain model because red doesn't exist in this model. I hope this makes sense.

1 Reply