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.


"HRlady" wrote:

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