Try this:

For an input area of A1:A100
Select that range, with A1 as the active cell

DataData Validation
Allow: Custom
Formula: =A1<MAX($A$1:$A$100)
Error Alert: Information
(enter the message you want displayed)
Click [OK]

That will display the message whenever the new amount is greater than or
equal to the maximum value in Cells A1:A100.

Does that help?

***********
Regards,
Ron


"billy boy" wrote:

I have a spread sheet with lots of data. The top row of each column looks for
the max number in that column. Is there a way for excel to warn me when
entering data that the number I just entered was max in that column. That
would really help me out. Thanks