Create error message if number entered is greater than previous ce

[Joe Lewis]

I want to create some sort of error message or warning if the user enters a
number that is higher than the cell before it. How can this be done? Thanks!

-Joe Lewis

 

[Dave Peterson]

Maybe you can use Data|Validation.

If you have trouble, you may want to share what the "cell before it" means.

If A2 is the cell, then is A1 the cell before it?

select A2:X999 (whatever cells you want)
Data|validation (xl2003 menus)
Settings tab
Allow: Decimal (or Whole number???)
Data: Less than (or less than or equal???)
maximum: =A1

excel will adjust the ranges for the other cells in the selection.

 

[Joe Lewis]

Thanks. Data Validation is what I wanted.

Joe

Maybe you can use Data|Validation.

If you have trouble, you may want to share what the "cell before it" means.

If A2 is the cell, then is A1 the cell before it?

select A2:X999 (whatever cells you want)
Data|validation (xl2003 menus)
Settings tab
Allow: Decimal (or Whole number???)
Data: Less than (or less than or equal???)
maximum: =A1

excel will adjust the ranges for the other cells in the selection.