Conditional Formatting Help

%3CLINGO-SUB%20id%3D%22lingo-sub-3179618%22%20slang%3D%22en-US%22%3EConditional%20Formatting%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3179618%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20attempting%20to%20build%20a%20spreadsheet%20that%20highlights%20team%20members%20in%20office%20days%20based%20on%20their%20selected%20schedule%20and%20also%20keep%20track%20of%20absences.%20What%20I%20am%20looking%20for%20is%20how%20to%20use%20conditional%20formatting%20on%20each%20row%20to%20highlight%20the%20days%20based%20on%20the%20days%20in%20office%20indicated%20in%20ROW%20A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22DerekM04_0-1645115289316.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F349112i786A81B2CA5D5970%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22DerekM04_0-1645115289316.png%22%20alt%3D%22DerekM04_0-1645115289316.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3179618%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-3180556%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20Formatting%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3180556%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1310426%22%20target%3D%22_blank%22%3E%40DerekM04%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DAND(RIGHT(%24A3%2CLEN(%24A3)-SEARCH(%22%2F%22%2C%24A3))%3D%22T%22%2CJ%241%3D%22Tuesday%22)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3EMaybe%20with%20this%20rule%20for%20conditional%20formatting%20as%20shown%20in%20the%20attached%20file.%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3D%24J%243%3A%24P%2413%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3EIn%20the%20example%20the%20conditional%20format%20is%20applied%20to%20the%20above%20range.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I am attempting to build a spreadsheet that highlights team members in office days based on their selected schedule and also keep track of absences. What I am looking for is how to use conditional formatting on each row to highlight the days based on the days in office indicated in ROW A

DerekM04_0-1645115289316.png

 

1 Reply

@DerekM04 

=AND(RIGHT($A3,LEN($A3)-SEARCH("/",$A3))="T",J$1="Tuesday")

Maybe with this rule for conditional formatting as shown in the attached file. 

=$J$3:$P$13

In the example the conditional format is applied to the above range.