Sure. We just need to assume that either A2 is entered first and the
validation go on A3 or visa versa.
--
Gary''s Student - gsnu200760


"Suzanne" wrote:

Thanks -- I was working the formula backward.

Is there any way to do this in data validation? (the number of rows may vary
between 2 and 2,000)

"Gary''s Student" wrote:

=IF(A2="","",IF(A2<A3,"Y","N"))

--
Gary''s Student - gsnu200760