Try this in the Data Validation setup window:

Formula: =(A1<MAX($A$1:$A$20,$A$30:$A$40))

Does that do what you want?

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


"billy boy" wrote:


Ron,
Thanks, it works perfect and I was wonder what the formula would be for
cells like a1 thru a20 then skip a few cells then a30 thru a40?
Thanks again
"Ron Coderre" wrote:

That formula goes in the formula field of the Data Validation setup window.

Does that help?

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


"billy boy" wrote:

Ron,
Where do I put the formula?

"Ron Coderre" wrote:

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