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

Excel offers several easy ways to calculate expiry dates. This post explores different ways to automate expiry date calculations in Excel.

Inserting Drop-Down Lists with Data Validation Once you have created named ranges for your lists, the next step is to insert the drop-down lists using Excel’s data validation feature.