compare min and max ranges

I have a job where I am putting numbers into a spreadsheet. I want to have excel compare that number or value to a known min and max that that number cannot go below or exceed; and if it does a red flag comes up or a pop up window. The data is in fraction and decimal format.

I hope someone can help with this problem
Thank you
[email protected] if you want to email directly

Data > Validation > Whole Number (or Decimal), ...