Automation, send email or red flag if cell value exceeded

[Daniel]

How to write a macro so that if a value in a cell is exceeded, the excel
window will flash or turn to red?

In a financial excel spread sheet, a manager has to keep track on the total
money
every day. If the money is exceed a certain value he has to take actions.

How to make this automation by flashing or turn red or even better send
email?

Thanks
Daniel

 

[ryguy7272]

Ron de Bruin is pretty much the master of this stuff!!
http://www.rondebruin.nl/mail/change.htm

Oh, and this is worth a look too:
http://www.contextmagic.com/express-clickyes/
I don't think you will be sending multiple emails, but if you do, run that
small utility. Try sending multiple emails without it, and try sending
multiple emails with it...it's magic....

Regards,
Ryan---

 

[Ron de Bruin]

Or use Outlook 2007 or CDO or redemption

See
http://www.rondebruin.nl/mail/prevent.htm

 

[Daniel]

Thanks Ron
I tried this by copying and paste to sheet tab/view code but I have to run
macro manually. How to be automation when the value of a cell exceed exp 200

 

[Ron de Bruin]

See
http://www.rondebruin.nl/mail/change.htm

 

[Daniel]

Hi Ron
Why I have to hit yes to allow to send email message. How to make it
automatically?
Daniel

 

[Ron de Bruin]

See
http://www.rondebruin.nl/mail/prevent.htm