Hi all,

I have 3 cells in sheet1

qty to sell 100

qty adjusted 15

current qty 105

if user puts in the qty adjusted 15 items will give qty to sell 11
which is over 105 items in current qty should stop the trade or give
warning message .

If qty to sell is less than or equal current qty 105 items , that i
correct.

How to do data validation on qty to sell not go over current qty ?

Thanks in advance

--
mtlp
-----------------------------------------------------------------------
mtlpp's Profile: http://www.excelforum.com/member.php...fo&userid=2334
View this thread: http://www.excelforum.com/showthread.php?threadid=38763

you can use the standard data validation possibility:

because you may enter a formula into the maximum value
= A1+A2
for example