Value filtered by and between multiple values in table

[JHSS_1]

Trying to find a way to parse out data when record falls between another record. Example on 12/10/18 - Kevin time is doubled on that day....one foreman entered his time from 8-4 and another foreman entered his time from 10-2. Since it is doubled up, I need to highlight that error. Tried various pivot view, with no promising results. In the end, I need to only show records where there is a conflict from the table. Any help would be appreciated.

Date	Emp	Start Time	End Time	Start Number	End Number	Hours	Foreman
12/8/2018	Kevin	12/8/18 8:00 AM	12/8/18 3:00 PM	43442.33	43442.63	7	Harry
12/9/2018	Kevin	12/9/18 9:00 AM	12/9/18 2:00 PM	43443.38	43443.58	5	Harry
12/10/2018	Kevin	12/10/18 8:00 AM	12/10/18 4:00 PM	43444.33	43444.67	8	Harry
12/10/2018	Kevin	12/10/18 10:00 AM	12/10/18 2:00 PM	43444.42	43444.58	4	Sam
12/11/2018	Kevin	12/11/18 8:00 AM	12/11/18 2:00 PM	43445.33	43445.58	6	Harry
12/11/2018	Kevin	12/11/18 2:00 PM	12/11/18 5:00 PM	43445.58	43445.71	3	Sam

<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[Chrisdontm]

Try This;

Copy this formula;

=AND($C3>$C2,$C3<$D2)

Then highlight all the data in columns C & D that you want alerted

Then, on the Home tab click Conditional Formatting in the Styles Group

Go down and click New Rule

Then go down and click Use a formula to determine which cells to format

Then in the middle box, paste the formula

Then click the Format button just below and choose a color to fill it with or choose other tabs to format further

Then click OK

Then click OK

Then click Apply

<colgroup><col style="mso-width-source:userset;mso-width-alt:5193; width:107pt" width="142" span="5"> </colgroup><tbody>
</tbody>