My sheet contains a list of planned events.

In column A i have the start time, in column B i have the stop time and in column C i have the status for each event. Additionally, in column D i have the events titles.

I want to check if any events whose status has been set as "pending" overlap.

If two or more events overlap i want to add a red background to the cells A, B, C in the rows that contain information for the overlapping events.

For example, if the events in row 7 and 13 overlap at all (which means that the dates in A7 and/or B7 are between the dates of A13 and B13) and both C7 and C13 are "pending" i want to add a red background to the cells A7,B7,C7,A13,B13,C13.

I have already made a few attempts but i couldn't get them to work as they either highlight the wrong cells or the macro takes forever to execute.

It would also like to have a msgbox saying that the events [Insert title from D7] and [Insert title from D13] overlap.

Thank you for your time and patience.

PS: I have to insist on using macros instead of conditional formatting, because this is a document other people use at work and i don't want them messing up the formatting rules when they copy cells. I have actually made a great amount of progress with VBA coding for this spreadsheet and this is the last thing i want to add to the document.