This article provides step-by-step instructions for color customizing your drop-down list in Microsoft Excel.

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

Image: Imam Fathoni, Getty Images/iStockPhoto You can use a Microsoft Excel drop down list to display a simple list, though sometimes you need a bit more control. Let’s suppose you have ...

Drop-down lists in Excel let you create a list of valid choices that you can select for a given field. We'll show you how to use tables, named ranges, formulas, data validation, and table styles.