Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Alert when conditions are met
I'm wondering if it is possible to get Excel to alert the user if a cell that
contains a formula exceeds a restriction? In my case: cell B1:B12 are inputs, B13 is the sum and B14 is the upper limit for B13. I'm using Conditional Formatting, but it only turns the cell red. I want Excel to alert me with a text-box when B13 exceeds B14. Is this possible? Thanx in advance... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Alert when conditions are met
Use the calculate event to check
See Chip Pearson's site for information on events http://www.cpearson.com/excel/events.htm -- Regards Tom Ogilvy "KingKarl" wrote in message ... I'm wondering if it is possible to get Excel to alert the user if a cell that contains a formula exceeds a restriction? In my case: cell B1:B12 are inputs, B13 is the sum and B14 is the upper limit for B13. I'm using Conditional Formatting, but it only turns the cell red. I want Excel to alert me with a text-box when B13 exceeds B14. Is this possible? Thanx in advance... |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Alert when conditions are met
There are several ways.
1 possible way is to use Validation. Select cells B1:B12 , Click menu Data, Validation. Select 'Custom' from droplist and enter =$B$13<=$B$14 in the formula. Now when a user enters a value in B1 ~ B12 that makes B13 exceed B14, a Retry/Cancel box will appear. The user will have little clue why though, unless you specify a custom message (you do this on the 'Error Alert' tab when setting up the validation rule!) Let us know if this is no good & I or someone else will show you another way. NOTE: although this works for typed values, pasted values are not covered (you would need to handle this differently) Regards - Steve. "KingKarl" wrote in message ... I'm wondering if it is possible to get Excel to alert the user if a cell that contains a formula exceeds a restriction? In my case: cell B1:B12 are inputs, B13 is the sum and B14 is the upper limit for B13. I'm using Conditional Formatting, but it only turns the cell red. I want Excel to alert me with a text-box when B13 exceeds B14. Is this possible? Thanx in advance... |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Alert when conditions are met
Worked perfectly well :-) thanx
Stevie_mac skrev: There are several ways. 1 possible way is to use Validation. Select cells B1:B12 , Click menu Data, Validation. Select 'Custom' from droplist and enter =$B$13<=$B$14 in the formula. Now when a user enters a value in B1 ~ B12 that makes B13 exceed B14, a Retry/Cancel box will appear. The user will have little clue why though, unless you specify a custom message (you do this on the 'Error Alert' tab when setting up the validation rule!) Let us know if this is no good & I or someone else will show you another way. NOTE: although this works for typed values, pasted values are not covered (you would need to handle this differently) Regards - Steve. "KingKarl" wrote in message ... I'm wondering if it is possible to get Excel to alert the user if a cell that contains a formula exceeds a restriction? In my case: cell B1:B12 are inputs, B13 is the sum and B14 is the upper limit for B13. I'm using Conditional Formatting, but it only turns the cell red. I want Excel to alert me with a text-box when B13 exceeds B14. Is this possible? Thanx in advance... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
alert | Excel Worksheet Functions | |||
Countif Conditions - Use of conditions that vary by cell value | Excel Discussion (Misc queries) | |||
2 Conditions + Sum of a colum matching those conditions | Excel Worksheet Functions | |||
shade cells based on conditions - i have more than 3 conditions | Excel Worksheet Functions | |||
How to multiple conditions to validate more than 2 conditions to . | Excel Worksheet Functions |