To apply data validation rules to a selected cell or range, head to the "Data" tab on the ribbon, and click the top half of ...

If you see the error “This value doesn’t match the data validation restrictions defined for this cell” when entering a value in an Excel cell, the solutions ...