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

How number formats work in Excel A cell in Excel can contain different kinds of data, which in turn can be formatted in different ways.