A common use of data validation is to create a drop-down list. Use it to restrict the type of data that users enter into an Excel cell.

How to Make Colors Change With Validation in Excel. Excel's conditional formatting tool applies formatting depending on cells' contents. Validation rules can change cells font, style, size or border.

Excel's data validation feature is more versatile than you might think. Learn how to use literal values, input values, list values, and even formulas to restrict input date values using data ...

In many cases, you want people to enter a valid date, and no other type of information, when they're putting data into a cell in Microsoft Excel.

If Excel is not highlighting cells in the formula, enable 'Allow editing directly in cells' and 'Enable fill handle and cell drag-and-drop' in Excel options.