Conditionally format multiple dates in a single row

[Henz]

I'm seeking help. I'm trying to conditionally format multiple dates for one person from a report and project them onto a roll book
The report generates workplace names and the type of leave they will be taking within a date range.
I will provide an example workbook but for reference the data is generated like this:
ID NO~PERSON~TYPE OF LEAVE~BEING~END DATE
~123~PERSON A~SICK LEAVE~01/01/22~02/01/22
~123~PERSON A~LEAVE~05/01/22~07/01/22
I Import the data as a text file and delimit it to break it up.
I'm hoping this can be acheived.
I'm aware of the following formulas OR(AND( set the ranges ) but the report is never the same each month one person can take multiple or one type of leave.
Any help is much appreciated.

[bebo021999]

Person name in Report list is not exactly (PERSON A with trailing space). I would suggest using the ID instead.
Try in C2:
=SUMPRODUCT(($A$7:$A$15=$A2)*($C$7:$C$15<=C$1)*($D$7:$D$15>=C$1))

CF formula in C2:
=SUMPRODUCT(($A$7:$A$15=$A2)*($C$7:$C$15<=C$1)*($D$7:$D$15>=C$1))>0

Apply to whole month

[Henz]

Perfect Bebo. The use of individual ID works great. Is there a way to differentiate types of leave by color?

[bebo021999]

For example, CF for "SICK LEAVE"

=SUMPRODUCT(($A$7:$A$15=$A2)*($B$7:$B$15="SICK LEAVE")*($C$7:$C$15<=D$1)*($D$7:$D$15>=D$1))>0
Pick a colour

Similar to other leave

[Henz]

Thanks for the help, the formula works as wanted. The issue I have run into now is the worksheet is tremendously slow and wont let me scroll down at times or freezes. Is there a fix for this?

[Henz]

I had a spark of inspiration and fixed my issue by using COUNTIFS made it much quicker