| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula to show the message that number already entered | Excel Worksheet Functions | |||
| How to give an error message if a cell value entered is larger than permitted | Excel Discussion (Misc queries) | |||
| Inserting current date when number entered in cell & Circular reference error? | Excel Discussion (Misc queries) | |||
| Need to create a error message box | Excel Worksheet Functions | |||
| counting number of times value is greater than previous week | Excel Worksheet Functions | |||
Linear Mode
