How to do number input validation?

  • Thread starter Thread starter Mark J
  • Start date Start date
M

Mark J

I am working on a modeling spreadsheet set up by a past employee.

We have some input fields, when I put in a number (besides the default
found in another cell), the cell turns yellow. This is a nice feature
in that it shows what values have been changed.

In addition, it does some kind of validation. If the range of values
is supposed to be 1 to 10, and you put in 14, excel pops up a window
saying "please put in a value between 1 and 10"

These are great, but I cannot figure out how it is done.

Someone please tell me the secret, or what these features are called
so I can look them up in the help fields.

armk
 
If you go to the Data Menu, then select Validation, this is how the past
employee got the fields to validate. You can specify the type and
value range of inputs into the cells you validate.
 
Back
Top