megha
03-01-2018, 12:32 PM
We have schedule in excelfile I want to make the auiting process autometically using macro o look for followings:
Any missed/open shift
Night to Day shift (meaning someone has not been schedued for Night Shift today and Day shift tomorrow)
Highlight with different color when someone is scheduled for more than 7 days
Highlight wth diferent color when someone is scheduled for 4 nights
Attached file is the sample. How do i start on this?
Thank you in advance!
Any missed/open shift
Night to Day shift (meaning someone has not been schedued for Night Shift today and Day shift tomorrow)
Highlight with different color when someone is scheduled for more than 7 days
Highlight wth diferent color when someone is scheduled for 4 nights
Attached file is the sample. How do i start on this?
Thank you in advance!