Could a Conditional Formatting color RED if there is any overlapped times?

Afternoon, I have J and K columns with times
which are from starting time to end time.
Example:
J1 5:10 pm K1 5:20 pm
J2 6:25 pm K2 6:35 pm
J3 6:35 pm K3 6:50 pm
J4 6:40 pm K4 7:10 pm
J5 5:15 pm K5 5:30 pm
and so on...
I like to CF the overlapping
times that in this case are:
J4 and K3
also
K1 and J5
The range is from J1 to K500 and goes from am to pm all over.
In simple words, they are events and no event can possible
happen at the same time so RED color will let me know
the mistake made on the times.
Thanks.

Try this CF formula, if you have Excel 2021 or 365:

Please Login or Register  to view this content.

Thanks for your answer but I have XL 2007.
Also I would like the RED CF going on the times that
are overlapping on the specific cells that they overlap, that is, applied to columns J and K when overlapping is found.

Quick explanation of my definition of overlap:
7:35 am to 8:05 am
8:05 am to 8:20 am
is NOT overlap.

Now this next one IT IS:
7:35 am to 8:05 am
8:00 am to 8:20 am
in the first example the first event ends and then the second starts at the same time which is okay.
in the second example the first event ends and then the second starts before the ending time of the first, that is overlapping.

Thank you very much! it works perfect for my purposes.
My apologies for the late reply, just got back to it today,
BTW today is the D Day, salute to all who battle for USA on 6-6-44,
since Google Doddle will NOT care to show it.
Thanks again.

I know is maybe not okay to post a new post
related to another one but it will save everyone
time. I posted on 6-6-23 a few days ago the one called:
COULD A CONDITIONAL FORMATTING COLOR RED IF THER IS ANY OVELAPPED TIMES?
Well the problem was solved and I labeled at SOLVED. BOTH CF formulas worked for that specific RANGE.
The issue now is when I copy and paste to another range it does not work.
CF Formula was applied from J1 to J5, then the other formula was applied from K1 to K5.
Now the copy and paste goes from J15 TO J19 and from K15 to K19 but it does not
give me the same results, in other words, it does not work like in the original RANGE.
Thanks

To conditionally format J1:J5 try: =SUMPRODUCT((K$1:K$5>J1)*(J$1:J$5<J1))>0
To conditionally format K1:K5 try: =SUMPRODUCT((K$1:K$5>K1)*(J$1:J$5<K1))>0
These above are the formulas that solved it for me.
When copying and pasting to another range IT DOES NOT WORK.

Thank you very much for the answer but probably I did not explain myself
well, my apologies since I just mention one more range. The substitution of numbers I can do them, but I will have to
do it every time. There are not only two ranges they are a bunch of them going down my worksheet.
So, the question will be: Can that range with the two formulas be copied and paste down the worksheet
several times? I did it but it did not work like the original one, then I removed the $ sign, still DIDNT work.

Yes, you file is exactly alike to mine, and your formula is perfect,
The only issue is that every range (like J1:K5 and J15 : K19) is a day of the week so I will have to add
363 more ranges separated by the coma, and YES it makes sense and I understand it.
I was thinking XL would have an easier way to do it.
I'm used to copy and paste formulas in different ranges and use $ or not
as needed for relative or absolute results but not in CF, I guess it is different.

Sorry, meant "a day of the year"

I had to do some adjustment to my worksheet and some changes since I have populated already those rows you used but it will
work for me, Thanks, you are a heck of a moderator instead
of worrying about double posting or other inconsequential issues you
really worked yourself on this one. I never lost hope
and I really appreciate it. Today, we in the USA are proud of you.
Thanks again.