Hello everyone,
I have a shift schedule workbook that needs repair
I want CF, If :
- employee has already worked 3 weekends (saturday or sunday, or both), and user wants to assign job for a day on the last weekend.
In other words, employee must be free at least one weekend in month, otherwise CF must colour weekend cells.
Please take a look at sample, CF should look something like that - I provided only one employee, but CF should work for all !
P.S. : A VBA solution would be even better (with msgbox for warning) - but don't know that either...
If anyone has a suggestion, please provide me an answer
Bookmarks