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

You can add line styles and color in the drop-down list by clicking Line Styles and Line Color from the list. Option two is to click Font Settings, a small arrow on the bottom in the Font group.