I am looking for a way to automatically fill the cell color of one cell based on a range of times represented in another cell.
So for example, I have column B which lists employee's schedules in the format of 8-4, 9-5, etc. These values are being referenced from another worksheet that contains the master schedule. Next I have times listed in row 6 in the format of 8, 9, 10, etc. What I would like to have happen is if an employee is scheduled to work 12-3, I want the 12, 1, 2 and 3 cells in their respective row to highlight red.
Appreciate any help! TIA.
So for example, I have column B which lists employee's schedules in the format of 8-4, 9-5, etc. These values are being referenced from another worksheet that contains the master schedule. Next I have times listed in row 6 in the format of 8, 9, 10, etc. What I would like to have happen is if an employee is scheduled to work 12-3, I want the 12, 1, 2 and 3 cells in their respective row to highlight red.
Appreciate any help! TIA.
