cell validation based on last value entered

Hello,

I am trying to do the following:

Lets say I have an excel sheet where the first column are player names from a sports team.
I am going to take a few photos of each player (not necessarily in the same order as they are in the excel sheet)
as I take the photos, I then type in the last photo number taken for that current player in column B next to that players name.

What I want to to do is validate what I am typing in.I want to check the following:
1. the value I entered is greater than the previous photo number entered for the last player (because photo numbers always increase
and there are times when a number is incorrectly entered)

2. the value I am entering is not more than 10 higher than the previous entered number for previous player


Is this possible? either in excel 2003 or 2010?


thanks!

Assume the first player photo # is in B2,So B3 to down use this in validation.

Data Validation >> Whole Number >> Between

Minimum: =B2+1
Maximum: =B2+10

copy B3 & down paste special >> validation.