Alert when conditions are met

[Guest]

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...

 

[Tom Ogilvy]

Use the calculate event to check

See Chip Pearson's site for information on events
http://www.cpearson.com/excel/events.htm

 

[Stevie_mac]

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.

 

[Guest]

Worked perfectly well thanx

Stevie_mac skrev: