My suggestion is to apply conditional formatting for the instances in which duplicate entries for "Role supporting" , "Shift" and Doctor/Staff Nurse/HCA are found. You can try this for example by selecting "Doctor4" in cells D2 and D3. Data validation and conditional formatting.xlsx9 KB...
with live each stage status. Now we are in the situation to finally find a suitable yet simple scheduling system. I could partially build an excel sheet usingsolverwhich can suggest ideal schedule but it’s not complete, and I am afraid that it is so much manual...