Aug 21 2021 12:34 PM
I don't know if this is possible, but I need to create an employee schedule from a lookup table that automatically highlights the cells in the row that each employee is scheduled to work in a week.
The lookup table will have each employee's name, the day, and the hours. I'm attaching a rudimentary sample.
Aug 22 2021 11:18 AM
I assume that's a rudimentary example, to use your words, of the output you want. But you don't show the source data that would be needed to populate that; presumably you have created that lookup table as well and can post a more complete, even if still rudimentary, sample.
That way I or somebody else here can help with the full process. How the conditional formatting would work would, I'm pretty sure, in some ways be a function of the formulas filling that schedule in the first place.