Do you know how to apply Conditional Formatting (CF)? This should be easy to google, so I will not lay out the details here.
I've added another column to the left of the staff names. This column would have the staff titles (I had just recently seen the Lego Batman Movie).
The following are the formulas used in CF:
For over 9 hour shifts:
The over 9 hours shift CF formula above needs to be the top-most CF rule for it to override the other CF rules.
I had to modify Phuocam's formula to account for columns being added or shifted.
Bookmarks