May 02 2023 01:01 PM
May 02 2023 02:42 PM
@Hans Vogelaar Sure.
|Name||Date||Start Time||Stop Time||Type|
The data set is more than 5,000 rows, has multiple names, and several types. I need to identify overlaps in time that occur on the same day for the same name, with a Type I.
May 02 2023 02:59 PM
Assuming that the data are in columns A to E, with headers in row 1:
Select the data rows, starting with A2:E2.
The active cell in the selection should be in row 2.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula
Adjust the ranges as needed.
Activate the Fill tab.
Select a highlight color.
Click OK, then click OK again.
P.S. This will not flag directly adjacent time periods, such as the last two rows in your example (one ends at 0930, the other starts at 0930).
If you want to flag those too, change the formula to
May 02 2023 03:26 PM