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