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

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" <[email protected]> wrote in message
news:[email protected]...
> 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...

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" <[email protected]> wrote in message
news:[email protected]...
> 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...

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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...
>
>
>