Validation will work that way. Enter =A4+1 in A5 as suggested will not alter
the validation, will just be checked against it.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"hustla7" wrote in
message ...

Sorry, I didnt make the problem clear enough, i also have a validation
in the column saying that no two values should be the same- if i enter
a formula into the cell- the validation doesn't work- i need to be able
to have both working---thanks a lot for ur help!


--
hustla7
------------------------------------------------------------------------
hustla7's Profile:
http://www.excelforum.com/member.php...o&userid=37760
View this thread: http://www.excelforum.com/showthread...hreadid=573417