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

In normal circumstances, Excel places a limit on the number of nested conditional formulas that you can use. The limit is 7. However, it is possible to circumvent the limitation over the number of ...