How to carry out a validation check in?

It all depends on your data (numbers/text). It automatically checks data validation when you enter new data and when you setup a validation rule it checks all existing data.