Returning an error message when a data value entered is not within range

Data validation is probably your best option.

1.Select all the cells where data is input
2. Select Data validation from the ribbon
3. Under the "Allow", select Whole Number
4. Then set the values for between 1 and 10.

You can also add custom error messages on the tabs of the data validation form

anytime bro