Help in conditional Formatting

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:
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.

The question is Cross posted on -chandoo.org/forum/threads/help-with-conditional-formatting . I have still not found a solution and request you to post possible solution on my original thread. I will be updating the both the forums with the answer if I get any

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. As you are new here I am providing the link for you this time.)

https://chandoo.org/forum/threads/he...matting.41619/

I have posted it already - see the end of my post.

You don't need to - providing links is all you have to do. Cross-posting is covered in our rules (link at the top of the page).

Read this to understand why we (and other sites like us) consider this to be important.