I've taken a different approach to the schedule you created.
It's fairly simple and assumes a working shift has the value 0 and non-working is 1.
I have populated the sheet with random 0 and 1.
If a person has too many RDO's the name is highlighted with red.
/Møller
|