I am trying to build a daily work schedule for my team where I have the agents name, their scheduled activities and their start and end times (Coloum A to D).
I need help in conditional formatting to
1) Highlight the Shift time for all the agents with one color as seen for Tom and Gary
2) Every agent will have some additional activities like Meal, Training,Coaching etc.. with their start and end times. I want those hours against those agents to be highlighted with a different color
Example:
I need help in conditional formatting to
1) Highlight the Shift time for all the agents with one color as seen for Tom and Gary
2) Every agent will have some additional activities like Meal, Training,Coaching etc.. with their start and end times. I want those hours against those agents to be highlighted with a different color
Example:
- Tom works Shift 10am to 5 pm . So cell H3:O3 is highlighted in yellow, Similarly for agent Gary E4: N4
- Now Tom also has another activity "Meal" between 12pm and 1 pm , so I want J3:K3 to be Green. He has "Training" from 11am to 12 pm,so I want I3:J3 to be blue.
- Similarly if you see for Gary his regular shift is from 7 am to 4pm which is highlighted in Yellow , but he as activities like "Coaching", "Meal","Break" etc at different times during his shifts. I want those times to be highlighted with a different color
- Note I have 200 individual agents and 12 different kind of activities . So in Coloum A - Tom might be repeated a couple of times with his activities in coloum B ( See A3 - for his regular shift and A8&A9 for his other activities) . Similarly for Gary
Attachments
Last edited: