Weekly Staff Schedule

Hi

I am do staff rostering. I wish to do some conditional formatting to remind me that I omitted "Day-Off" for that week and "Sleeping Day" for that particular 3 consecutive Night duty.

Please assist.

Thanks and regards

Nancy

Could you provide an example worksheet that shows how you have the entire month set up? I have most of the coding figured out for you but for the consecutive N's if the 4th day falls on a M, T or W then the coding will need to be altered depending on how your calendar is set up.


Thanks!

Hi

Thank you for the assistance.

Please refer to the attached.