Conditional Formatting that would trigger an email

[amcmc]

Is this possible?

Basically i have a document that when a value exists under two and both cells then i would like that to trigger an email being sent to a specific person.

please help

 

[lenze]

Hi and welcome to the board!!
Yes, but it can be complcated. I suggest you do a search on the board for "Conditinal Email" and on Google for "Conditional Email in Excel" I'm sure there exist code that does this.

lenze

 

[VoG]

This may get you started http://www.rondebruin.nl/mail/change.htm

 

[amcmc]

thanks guys this is more complicated than i expected. i'll have to play around with the information you guys have provided.