Alert validation while moving on next record

Summary:

How can make alert fire before moving next record instead of saving.

Content (required):

We have applied validation on % that this percentage amount can not be greater than 1000 now if we have 10 records at worksheet and manager enter more than 1000 on each records then system will not fire on each records.

Requirement : system must fire alert when move next records so we can stop or intimate user instead of he entering data in all ten records and while saving system intimate him which is wastage of time.

Version (include the version you are using, if applicable):

22B

Code Snippet (add any code snippets that support your topic, if applicable):