Formula needed - Red flag / highlight / bold if colours

%3CLINGO-SUB%20id%3D%22lingo-sub-3099054%22%20slang%3D%22en-US%22%3EFormula%20needed%20-%20Red%20flag%20if%20colours%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3099054%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20tracking%20the%20ins%20and%20outs%20of%20the%20company%20where%20I%20work.%20I%20would%20like%20a%20red%20flag%20to%20appear%20on%20those%20people%20who%20have%20arrived%20late%20(light%20red)%20or%20have%20forgotten%20to%20sign%20in%20(dark%20red).%3C%2FP%3E%3CP%3EI%20have%20used%20the%20conditional%20formatting%20but%20I%20am%20not%20good%20enough%26nbsp%3Bwith%20the%20if%20formulas.%26nbsp%3BCan%20anyone%20help%20me%3F%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202022-02-01%20155217.png%22%20style%3D%22width%3A%20828px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F344171i402474A35EAFB6FE%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202022-02-01%20155217.png%22%20alt%3D%22Screenshot%202022-02-01%20155217.png%22%20%2F%3E%3C%2FSPAN%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3099054%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3099163%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20needed%20-%20Red%20flag%20if%20colours%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3099163%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1293541%22%20target%3D%22_blank%22%3E%40O_ON_8%3C%2FA%3E%26nbsp%3BYou%20only%20indicate%20when%20it%20should%20become%20dark%20red.%26nbsp%3B%3CFONT%20face%3D%22inherit%22%3EWhat%20are%20the%20rules%20for%20the%20other%20colours%3F%20I.e.%20when%20no%20longer%20green%20but%20orange%3F%20When%20should%20it%20become%20red%3F%20I%20can%26nbsp%3B%3C%2FFONT%3Eprobably%3CFONT%20face%3D%22inherit%22%3E%26nbsp%3Bguess%2C%20but%20it%20would%20be%20better%20to%20be%20precise.%20And%20why%20are%20a%20%22-%22%20and%2016%3A02%20grey%3F%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3103669%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20needed%20-%20Red%20flag%20if%20colours%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3103669%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B.%20I%20wasn't%20clear%20enough%20in%20my%20first%20message.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20used%20conditional%20formatting%20for%20the%20colours%2C%20depending%20on%20the%20time%20members%20of%20staff%20arrive.%20The%20software%20that%20we%20use%20only%20gives%20me%20the%20times%2C%20I%20have%20set%20the%20boundaries%20for%20the%20conditional%20formatting%3A%3CBR%20%2F%3EBefore%208h45%20--%26gt%3B%20green%3CBR%20%2F%3Efrom%208h45%20to%208h51%20--%26gt%3B%20orange%3CBR%20%2F%3Eafter%208h52%26nbsp%3B%20--%26gt%3B%20light%20red%3CBR%20%2F%3Eand%20those%20who%20have%20not%20clocked%20in%26nbsp%3B%20--%26gt%3B%20dark%20red.%3CBR%20%2F%3Eeverything%20in%20grey%20is%20because%20they%20are%20justified%20absences%20(not%20important).%3CBR%20%2F%3EWhat%20I%20am%20asked%20to%20do%20is%20to%20indicate%20the%20staff%20who%20are%20late%20(light%20red)%20or%20who%20forget%20to%20clock%20in%20(dark%20red)%2C%20so%20I%20need%20to%20find%20a%20formula%20that%20highlights%20or%20puts%20a%20little%20flag%20in%20the%20name%20box%20of%20the%20team%20member%20in%20question%2C%20so%20that%20it%20is%20easily%20visible.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20this%20helps%20understand%20better%20my%20problem.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I am tracking the ins and outs of the company where I work. I would like a red flag to appear on those people who have arrived late (light red) or have forgotten to sign in (dark red).

I have used the conditional formatting for the colours but I cannot find the formula to higlight/put in bold the name of those who are late. Can anyone help me?Screenshot 2022-02-01 155217.png 

 

2 Replies

@O_ON_8 You only indicate when it should become dark red. What are the rules for the other colours? I.e. when no longer green but orange? When should it become red? I can probably guess, but it would be better to be precise. And why are a "-" and 16:02 grey?

Thank you @Riny_van_Eekelen . I wasn't clear enough in my first message. 

I have used conditional formatting for the colours, depending on the time members of staff arrive. The software that we use only gives me the times, I have set the boundaries for the conditional formatting:
Before 8h45 --> green
from 8h45 to 8h51 --> orange
after 8h52  --> light red
and those who have not clocked in  --> dark red.
everything in grey is because they are justified absences (not important).
What I am asked to do is to indicate the staff who are late (light red) or who forget to clock in (dark red), so I need to find a formula that highlights or puts a little flag in the name box of the team member in question, so that it is easily visible.

 

I hope this helps understand better my problem.