Hello everyone, I am trying to create a sheet with all of the employees schedules. Basically if on Monday employee 1 needs to be available, I would need the available cell to highlight green and so on. However, the function I have only applies to times of the day, but does not apply to the day of the week. For example, employee 2 has off on tuesday; therefore, the conditional formatting that applied on Monday, should not apply on tuesday for him. Any help on how I can make this work?
Here I attach the sheet.
Bookmarks