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