View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
KingKarl KingKarl is offline
external usenet poster
 
Posts: 2
Default 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...