SUMPRODUCT AND CONDITIONAL FORMATTING

Copper Contributor

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.

 

1 Reply

@Word_Brand 

 

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.