PC Review
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Setup
Email from inside excel
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Setup
Email from inside excel
![]() |
Email from inside excel |
|
|
Thread Tools | Rate Thread |
|
|
#1 |
|
Guest
Posts: n/a
|
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 |
|
Guest
Posts: n/a
|
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" <KellyThompson@discussions.microsoft.com> wrote in message news:36B52AD2-D845-4BED-A868-A418972C0D46@microsoft.com... > 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 |
|
![]() |
|
| Thread Tools | |
| Rate This Thread | |
|
|

Main Page 

