As John said, Data Validation will do it.

If the DV cell and the MAX being checked are in different rows, use DV with
a type Custom and a formula of

=B6<=MAX(4:4)

If in the the same row, use a formula of

=B4<=LARGE(4:4,2)

The different formulae are because in the same row, the cell in question
could be the largest

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Damon Dutch Kash" wrote in
message ...
John - this would be great for a formula solution, I was hoping to do this
in
VBA script. Thanks, though. Anybody out there have a non-loop VBA
answer?

"John Keith" wrote:

Where Row 4 contains your data that you want to check against.
in A6 put this formula =IF(MAX(4:4)<B6,"Too big", "OK")
in B6 enter a new value.

Take a look at Data|Validation; that might work for you also.

--
Regards,
John


"Damon "Dutch" Kash" wrote:

is it possible to write a script that when a user enters a value, that
checks
to see if the value is greater than the maximum value of a row?