Create error message if number entered is greater than previous ce

  • Thread starter Thread starter Joe Lewis
  • Start date Start date
J

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
 
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.
 
Thanks. Data Validation is what I wanted.

Joe

Dave Peterson said:
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.
Click to expand...
 
Back
Top