Checking Errors on Sheet
There is an Excel file that teaches how to perform the Checking Errors on Sheet operation.
Excel Professional Checking Errors On Sheet
This workbook demonstrates checking errors on sheet using VBA macros on a 10-row data layout.
Hope it is useful.