Alert Creation for milestone

[fwoody]

Hi,

I run a sports club (cricket) and keep a tally of all the stats for the team. I am trying to create alerts when certain cells reach certain levels for the first time.

Each year has a spate sheet with all the stats with a sheet totalling all the stats. So for example, over the last 4 years a player has scored 924 runs and I want to be alerted when his total reaches 1000, 2000, 3000 etc. Preferably by some sort of notification.

I thought I could do this by using conditional formatting but that only works if the player hits 1000 exactly.

Any help would be appreciated.

 

[fwoody]

[TABLE="width: 1140"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Runs[/TD]
[TD]Balls[/TD]
[TD]Strike Rate[/TD]
[TD]Strike Rate Pts[/TD]
[TD]50s[/TD]
[TD]100s[/TD]
[TD]Wkts[/TD]
[TD]Overs[/TD]
[TD]Runs[/TD]
[TD]Econ[/TD]
[TD]Econ Pts[/TD]
[TD]3 wkts[/TD]
[TD]5 wkts[/TD]
[TD]Stumping[/TD]
[TD]Catches[/TD]
[TD]Man of Match[/TD]
[TD]Mention[/TD]
[TD]Total Points[/TD]
[TD]Games[/TD]
[TD]Average/Game[/TD]
[/TR]
[TR]
[TD]Player 1[/TD]
[TD]245[/TD]
[TD]128[/TD]
[TD]191[/TD]
[TD]15[/TD]
[TD]4[/TD]
[TD]0[/TD]
[TD]3[/TD]
[TD]6[/TD]
[TD]43[/TD]
[TD]7.2[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]515[/TD]
[TD="align: right"]5[/TD]
[TD]103[/TD]
[/TR]
[TR]
[TD]Player 2[/TD]
[TD]302[/TD]
[TD]182[/TD]
[TD]166[/TD]
[TD]10[/TD]
[TD]2[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]3[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]482[/TD]
[TD="align: right"]7[/TD]
[TD]68.857[/TD]
[/TR]
[TR]
[TD]Player 3[/TD]
[TD]217[/TD]
[TD]116[/TD]
[TD]187[/TD]
[TD]10[/TD]
[TD]2[/TD]
[TD]0[/TD]
[TD]6[/TD]
[TD]19.4[/TD]
[TD]201[/TD]
[TD]10.4[/TD]
[TD]-15[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]442[/TD]
[TD="align: right"]6[/TD]
[TD]73.667[/TD]
[/TR]
[TR]
[TD]Player 4[/TD]
[TD]246[/TD]
[TD]119[/TD]
[TD]207[/TD]
[TD]15[/TD]
[TD]3[/TD]
[TD]0[/TD]
[TD]2[/TD]
[TD]17.2[/TD]
[TD]140[/TD]
[TD]8.1[/TD]
[TD]-10[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]3[/TD]
[TD]0[/TD]
[TD]421[/TD]
[TD="align: right"]4[/TD]
[TD]105.25[/TD]
[/TR]
[TR]
[TD]Player 5[/TD]
[TD]213[/TD]
[TD]110[/TD]
[TD]194[/TD]
[TD]15[/TD]
[TD]2[/TD]
[TD]0[/TD]
[TD]5[/TD]
[TD]20[/TD]
[TD]166[/TD]
[TD]8.3[/TD]
[TD]-10[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]413[/TD]
[TD="align: right"]6[/TD]
[TD]68.833[/TD]
[/TR]
</tbody><colgroup><col><col span="20"></colgroup>[/TABLE]

 

[fwoody]

is that clear enough?

 

[Fluff]

You have 2 columns for runs, would I be right in thinking that the first of those is runs scored & the second is runs conceded, whilst bowling?
Also each player has played a number of games, so if, for example, player 1 scored 5 runs in the next match would you simply change the 245 to 250?

 

[fwoody]

Yes - I manually add the data after each match

 

[Fluff]

That makes things a bit more complex.
Let me think on it.