#1   Report Post  
Old December 16th 04, 04:25 PM
Kelly Thompson
 
Posts: n/a
Default Email from inside excel

What I have done is created a time sheet for a month, and it also gives me
the hours that are worked in a week. Do what I would like to do is when the
week goes over 40 hours send a email, a pop-up or some kind of message that
this person went over thier time. Can this be done?

Thank you

Kelly

  #2   Report Post  
Old December 16th 04, 09:22 PM
Bob Phillips
 
Posts: n/a
Default

I would use conditional formatting on that cell, and if the value is greater
than 40, set the colour to red.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Kelly Thompson" wrote in message
...
What I have done is created a time sheet for a month, and it also gives me
the hours that are worked in a week. Do what I would like to do is when

the
week goes over 40 hours send a email, a pop-up or some kind of message

that
this person went over thier time. Can this be done?

Thank you

Kelly





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel should not delete document after trying to send email 4rs Excel Discussion (Misc queries) 0 January 14th 05 04:39 AM
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 1 January 5th 05 08:36 AM
how to turn off email header with excel workbook larhere Excel Discussion (Misc queries) 0 January 5th 05 12:39 AM
Sending a email from inside Excel Kelly Thompson Excel Discussion (Misc queries) 4 December 16th 04 06:23 PM
Can I get email alerts when dates in excel are nearing? lucrecat Excel Discussion (Misc queries) 2 December 14th 04 05:14 AM


All times are GMT +1. The time now is 03:52 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017