Limiting User input to a minimum and maximum value

Hi.

Thanks in advance for your help with this.

I am trying to find a way to limit used input to between a maximum and minimum number. I think it may be using Custom Data validation, but it only seems to accept one variable.

For example, if cell A1=100,000 and cell B1=100, I would like to limit user input in cell C1 to a number between A1 (100,000) and B1 (100).

I appreciate your time with this.

Thanks for your reply. Not quite what I am trying to do. Cells A1 and B1 are variables. The user will be populating cells A1 and B1 with numbers. But I just want to limit the input into cell C1 to a number between A1 and B1.

Perfect. Thanks very much.