#1   Report Post  
Member
 
Posts: 89
Post Value Limits in a Cell

I need to be able to set a limit on a cell value and be able to warn if the threshold is about to be breached. For example:

If the maximum limit for a cell is 5,000 and it goes past 5,000, a warning message would be displayed alerting the limit being surpassed.
The cell is updated from another worksheet, so the value being added into it is not controlled from this spreadsheet (It's being referenced in). But, the warning should be seen from either the first spreadsheet (Where the value is being entered and then referencing the cell in question in another sheet), or in the spreadsheet where the cell is. Both would be great, if that's possible. Thank you in advance for any/all help in this matter.
  #2   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 11,058
Default Value Limits in a Cell

Consider using conditional formatting. It can be applied to both the cell
you desire to limit as well as the precedent cell.
--
Gary''s Student - gsnu200714


"frankjh19701" wrote:


I need to be able to set a limit on a cell value and be able to warn if
the threshold is about to be breached. For example:

If the maximum limit for a cell is 5,000 and it goes past 5,000, a
warning message would be displayed alerting the limit being surpassed.

The cell is updated from another worksheet, so the value being added
into it is not controlled from this spreadsheet (It's being referenced
in). But, the warning should be seen from either the first spreadsheet
(Where the value is being entered and then referencing the cell in
question in another sheet), or in the spreadsheet where the cell is.
Both would be great, if that's possible. Thank you in advance for
any/all help in this matter.




--
frankjh19701

  #3   Report Post  
Member
 
Posts: 89
Default

Could you give me an example, please?

Quote:
Originally Posted by Gary''s Student View Post
Consider using conditional formatting. It can be applied to both the cell
you desire to limit as well as the precedent cell.
--
Gary''s Student - gsnu200714


"frankjh19701" wrote:


I need to be able to set a limit on a cell value and be able to warn if
the threshold is about to be breached. For example:

If the maximum limit for a cell is 5,000 and it goes past 5,000, a
warning message would be displayed alerting the limit being surpassed.

The cell is updated from another worksheet, so the value being added
into it is not controlled from this spreadsheet (It's being referenced
in). But, the warning should be seen from either the first spreadsheet
(Where the value is being entered and then referencing the cell in
question in another sheet), or in the spreadsheet where the cell is.
Both would be great, if that's possible. Thank you in advance for
any/all help in this matter.




--
frankjh19701
  #4   Report Post  
Member
 
Posts: 31
Default

Quote:
Originally Posted by frankjh19701 View Post
Could you give me an example, please?
On the first cell (the cell where the data is input) you could use Data Validation.

To do this (in Excel 2007):
- Select the cell that the value is input into
- On the Data toolbar, select Data Validation
- On the Settings tab, enter Allow: Whole Number, Data: less than, Maximum: 5000
- On the Error Alert tab, enter the error message you want to appear when a value greater than 5000 is entered.

Now that it is impossible to enter a value greater than 5000, there is no need to display anything on the second sheet as the value will never go over 5000.

If you would prefer Conditional Formatting however, I am happy to give an example of this instead.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
PivotCharts (max cell/row limits)? tico6802 via OfficeKB.com Charts and Charting in Excel 0 June 13th 06 04:35 PM
Limits Student Excel Discussion (Misc queries) 1 December 7th 05 04:26 PM
cell format limits Mike Excel Worksheet Functions 1 August 21st 05 07:42 PM
Wrap text limits in Excel 2003 cell formatting Adelrose Excel Discussion (Misc queries) 1 April 19th 05 06:32 PM
dealing with cell text limits Walter Harley Excel Discussion (Misc queries) 3 March 5th 05 05:42 PM


All times are GMT +1. The time now is 09:25 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"