Some cells manually filled to show which cells should be highlighted when there is an overlap would hve helped.
But...
Maybe:
=AND(D5<>"",D5<C5)
applied to D5:X12. This highlights any start/end date that is EARLIER than any one to the left of it.
Bookmarks