I need to check that the values entered in a seperate sheet are entered
correctly within a certain range.

If the entry is out of range, the user must get an error message that the
entry is invalid.

For instance:
=IF(AND(A1=1;A1<=500);allow entry;disallow and prompt user because of
invalid entry)

What do I do?

Best regards,
Sonni