Hello everyone,
At work we use an excel spreadsheet to track which associates are present on which days of the week. Each associate receives a shift code that details what days of the week they work. For example NA5-1800 means the associate works Sunday-Wed every week. As of now we have to memorize each shift code and the corresponding days they will be present at work. I would like to create a conditional format that automatically highlights the shift code if the associate is scheduled to be at work today. Any help would be greatly appreciated. Thank you.
Bookmarks