Forum Discussion
EXCELL Conditional formatging
I have a spreadsheet that I download from our turnstyle in/out system. I use conditional formatting to see who leaves early (before 5:20, before 4:00 and before 2:00) we are building a power plant and we have 2 sites side by side so several employees go back and forth... I ONLY NEED HIGHLIGHTED THE LAST CLOCK OUT FOR EACH EMPLOYEE and not every time they punched the clock out in a days time.... Can you please assist me... @links to members
8 Replies
Please provide more detailed information - which columns contain what?
Preferably insert a screenshot and/or attach a sample workbook without sensitive info.
this is my report and were monitoring who left the job site early and not just back and forth between job sites... so we want the last time out instead of all the times in between and I pull this report from our badging system..
- I have highlighted the time out column and if you look in column c you can see the duplicated last names which tells me how many times they went in and out but I only want the last one...
Hello! You've posted your question in the Tech Community Discussion space, which is intended for discussion around the Tech Community website itself, not product questions. I'm moving your question to the Excel space - please post Excel questions here in the future.
EricStarker thank you very much for doing this for me...
