Data Validation in Microsoft Excel allows users to control the type of data entered into the worksheet. It picks from a list of rules to limit the type of data that can be entered into a cell.

How to change font color for an Excel drop-down list We’re going to combine the data validation control with the conditional formatting feature in order to apply a font color to the selected ...

Click the "+" sign at the bottom of Excel 2013 to create a new sheet to use as a data source. Enter the values you need for the first drop-down list in column A on the new sheet.

Here are four ways to express dates using data validation: literal values, input values, a list, and formulas. I’m using Excel 2016 (desktop) on a Windows 10 64-bit system.