Can Excel email someone when a cell goes + or - a value?

R

Reload Internet

So sort of like Conditional formatting where it changes colour - instead it
adds rules to send an automatic email... Is this reaching for the stars?
 
R

Reload Internet

Thanks!
But you can just give me the complete thing to paste in assuming it was cell
A1, value 200 + and I will set up my smtp server etc.

I was a bit confused by where to place the macro
 
Top