PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Setup Email from inside excel

Reply

Email from inside excel

 
Thread Tools Rate Thread
Old 16-12-2004, 04:25 PM   #1
=?Utf-8?B?S2VsbHkgVGhvbXBzb24=?=
Guest
 
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
  Reply With Quote
Old 16-12-2004, 09:22 PM   #2
Bob Phillips
Guest
 
Posts: n/a
Default Re: Email from inside excel

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



  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off