Pop up message

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Again, putting together employee schedule. How do I set it up so as I input
the schedule day by day if the total hours scheduled exceeds 40 it shows up
red with a message? Is that possible?

Thank you
 
You can do this via VBA but if you want just formulas... try this out.

In the cell that has the total hours,

1) click on Format---> Conditional Formatting
2) Select from the drop down list (value is greater than)... and put in 40
3) Select Format and change the cell font to red and bold it if you want

* This will change the number to red anytime it is over 40

If you want a message, go to the cell directly to the right or wherever you
want the message to appear. In that cell...

1) Insert the formula= IF("InsertTotalHourCell#HERE","Value is over 40"," ")

*This formula will leave the cell blank until the value gets over 40. Let me
know if this works.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding up total hours worked on employee schedule using various criteria 0
Automatic input 3
Access Dcount (multiple criteria) 3
Employee Scheduling Worksheet 10
Conditional Formatting & Data Validation? 1
Formula to Compute Overtime hours 1
Choose from list to fill a cell 1
Prevent duplicate data from being entered into the same column 3

Back
Top