Learn how to create a drop-down list in Excel without or with color using conditional formatting and data validation rules.

I often want to select more than one option in a drop-down list. For example, when there’s a collection of colors to choose from, I might like more than one color. Or, in a document where we ...