Someone else was asking that a while back, do you want it to do it with VBA or just a formula. I stuck an excel sheet here
http://www.mediafire.com/download/qjqx0 ... Book1.xlsx showing how to use =INDEX(A5:A100,COUNTA(A5:A100)) to pick out the bottom selection then just use an IF equals statement to fire any triggers