How to do number input validation?

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
 
T

Torcie

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.
 
Top