News

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.