You cound use data|validation, select custom and add the formula
=AND(A14,A1<31)

Lanceb

"Jeff Harmon" wrote:

I am trying to set up a spreadsheet which will indicate when the numbers
plugged into the text boxes are outside of a set range. For example, the
range for a certain set of numbers needs to be 5-30, and the number which I
enter in is 33, is there a way to set up the spreadsheet to indicate that the
number is not in that 5-30 range without my having to go back through and
physically check?