Weekly Staff Schedule

[nancyching1711]

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

[rvasquez]

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!

[nancyching1711]

Hi

Thank you for the assistance.

Please refer to the attached.

[Richard Buttrey]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.