SUMPRODUCT AND CONDITIONAL FORMATTING

%3CLINGO-SUB%20id%3D%22lingo-sub-2672150%22%20slang%3D%22en-US%22%3ESUMPRODUCT%20AND%20CONDITIONAL%20FORMATTING%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2672150%22%20slang%3D%22en-US%22%3E%3CP%3EI%20don't%20know%20if%20this%20is%20possible%2C%20but%20I%20need%20to%20create%20an%20employee%20schedule%20from%20a%20lookup%20table%20that%20automatically%20highlights%20the%20cells%20in%20the%20row%20that%20each%20employee%20is%20scheduled%20to%20work%20in%20a%20week.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20lookup%20table%20will%20have%20each%20employee's%20name%2C%20the%20day%2C%20and%20the%20hours.%26nbsp%3B%20I'm%20attaching%20a%20rudimentary%20sample.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2672150%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2673475%22%20slang%3D%22en-US%22%3ERe%3A%20SUMPRODUCT%20AND%20CONDITIONAL%20FORMATTING%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2673475%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F747330%22%20target%3D%22_blank%22%3E%40Word_Brand%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20assume%20that's%20a%20rudimentary%20example%2C%20to%20use%20your%20words%2C%20of%20the%20output%20you%20want.%20But%20you%20don't%20show%20the%20source%20data%20that%20would%20be%20needed%20to%20populate%20that%3B%20presumably%20you%20have%20created%20that%20lookup%20table%20as%20well%20and%20can%20post%20a%20more%20complete%2C%20even%20if%20still%20rudimentary%2C%20sample.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20way%20I%20or%20somebody%20else%20here%20can%20help%20with%20the%20full%20process.%20How%20the%20conditional%20formatting%20would%20work%20would%2C%20I'm%20pretty%20sure%2C%20in%20some%20ways%20be%20a%20function%20of%20the%20formulas%20filling%20that%20schedule%20in%20the%20first%20place.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New 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.