CF to color RED certain time plus specific name

[Frankxl]

=SUM((MOD($A$1-$A2:$A99,1)>MOD($B$1-$A2:$A99,1))+(MOD($B2:$B99-$A2:$A99,1)>MOD($B2:$B99-$A$1,1))+($A$1=$A2:$A99)+($B$1=$B2:$B99))

=(MOD($A$1-$A2,1)>MOD($B$1-$A2,1))+(MOD($B2-$A2,1)>MOD($B2-$A$1,1))+($A$1=$A2)+($B$1=$B2)

I got these two formulas from HansDouwe, thanks, however for another worksheet
just need a little adjustment or addition, sorry for posting again but I tagged that last post
as SOLVED prematurely. Last referred post was today at 2:08 pm. and here is a sample attached
of my worksheet which will only need to add the name in G as a criterion for the formula in Conditional Formatting.

[HansDouwe]

Hi Frank,
In the previous tread there were no names involved.

In the sheet I don't see that the CF rules are implemented. Otherwise James M's times in row 6 (10:30 - 12:35 overlaps 10:20 - 11:20) would also have been red.
Would that (red) have been correct in the new situation?

Do I understand you correctly when you want to add the name as an extra criterion?
And what about the overlap of the periods?
If the name is the same, is there no longer any need to pay attention to overlap in the periods?
After all, the times of John D in row 2 and 9 do not overlap with the times of John D in the first row.

[Frankxl]

Correct, this is another example, same and different worksheet as I added the names, sorry I did not do CF, but I colored it manually.
Basically, using the same 2 formulas you gave me I wanted to be true if the name repeats too.
So, if I have John Doe on top and his name repeats and also it is between the time on the first line with his name that's when I'd like the red.
In other words, RED will be if there is a time between 10:20 and 11:20 and only if John Doe is in G (it could be another name but as long as it is in G1 that's the one.

[Frankxl]

Do I understand you correctly when you want to add the name as an extra criterion?
Yes.

[Frankxl]

"After all, the times of John D in rows 2 and 9 do not overlap with the times of John D in the first row."
A: Correct that's why 2 and 9 need to stay black, however see that 10 is RED because overlaps and also has John Doe both criteria are met.
Remember since I do not have the formula those colors are manually done for visual explanation.

[HansDouwe]

Thx for the clarification.
Please see attachment for the results:

[Frankxl]

The file is exactly what I want, amazingly done. Congratulations and thanks.
What I now having issues is applying the formulas to the cells since I have G, L, M cells
and with CF is hard to see the entire formula and which cells carry them.
I'm a rookie remember. I did it with the first post even though it took me a while but
it will help me more, if it is not too much to ask to tell me what you did like:
which formula you put in which cells, using your own workbook just a brief description please.
It may be easy for you guys but I'm not getting it in my worksheet, been trying hard.
Something like this as you wrote in the first post if it is not too much to ask, please:

<<<<<<Please try this CF-rule applies to $A$2:$B$99:
Formula: Select Code copy to clipboard
=(MOD($A$1-$A2,1)>MOD($B$1-$A2,1))+(MOD($B2-$A2,1)>MOD($B2-$A$1,1))+($A$1=$A2)+($B$1=$B2)
Please try this CF-rule applies to $A$1:$B$1
Formula: Select Code copy to clipboard
=SUM((MOD($A$1-$A2:$A99,1)>MOD($B$1-$A2:$A99,1))+(MOD($B2:$B99-$A2:$A99,1)>MOD($B2:$B99-$A$1,1))+($A$1=$A2:$A99)+($B$1=$B2:$B99))>>>

[Frankxl]

I got it, finally, thank you much, no need to reply anymore.

[Frankxl]

Unfairly does not give me the chance to give you another reputation that you deserve.
Well, I appreciate your time and effort.
Thanks.