Highlighting times on a schedule based off of input

Hello all. I'm trying to have cells on a schedule highlighted according to input from another sheet. I am trying to attempt two things:
1. Highlight the time slots under the clients name according to their scheduled input and
2. Highlight the times according to colour that corresponds to the location in which they are meeting

Attached are photos to help clarify the situation.

Screen Shot 2018-10-09 at 1.46.21 PM.png
Screen Shot 2018-10-09 at 1.46.33 PM.png

I recommend uploading a small representative sample (Excel workbook not a picture) of your data along with the desired results (which you can enter manually) based on that data.

To upload an Excel workbook, follow these steps:
1) Click on "Go Advanced"
2) Click on "Manage Attachments"
3) Click on "Choose File"
4) Choose your file and click on "Open"
5) Click on "Upload"
6) Click on "Close this window"

I'm new to this forum. Did this work?

I appreciate your timely response.

Now, as much as I really do appreciate you helping me, could you explain to me what is going on in this formula? I like to learn what you did so I can break it down and apply it later.

Thanks again.

Sure, the formula counts the number of instances where ALL of the following are true for cell B4:

'Session Input'!$A$2:$A$1000 = B$3
'Session Input'!$B$2:$B$1000 ≤ $A4
'Session Input'!$C$2:$C$1000 ≥ $A4
'Session Input'!$D$2:$D$1000 = "Activity Offer"

It then essentially drags the formula across and down for the entire range that you selected before applying the Conditional Formatting.

Conditional Formatting sees 0 as FALSE and anything other than 0 as TRUE.
It will apply formatting to all of the cells that return TRUE.

I am coming to you with all my inquiries from here on out. Not only have you helped me resolve an issue, but I learned a new function. Thanks again.