Hi,
I want to create a time card which will generate colour coded warning if someone works either more, or less than their weekly contracted minuets.
Required:
If someone works less than 2,250 minutes (37.5 Hours), then wherever that employees name appears in the 5 time cards, the cell glows RED
If someone works more than 2,250 minutes (37.5 Hours), then cell glows GREEN
If someone works 2,250 minutes (37.5 Hours) exactly, then cell remains unchanged
The cell to be coloured is the cell in column B containing the name
Cells which have been greyed out will be hidden from view
Please see attached sample sheet.
Many Thanks,
Sean
Bookmarks