Create error message if number entered is greater than previous ce
 

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

Create error message if number entered is greater than previous ce
 

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 wrote:

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

Create error message if number entered is greater than previou
 

Thanks. Data Validation is what I wanted.

Joe

"Dave Peterson" wrote:

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 wrote:

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