Highlight Overlap dates

[sathishsusa]

Hi,

My previous post may not be explaining clearly to understand the problems. Let me try to give some more clear solution to understand what results I need in my file.

I have a Four Employees. Each employee they want to prepare a leave plan for year 2017. If employees, they want to apply leave Rule is there should not be any overlap date with other employee’s dates.

Now I wish to compare the employees overlap dates by selecting the checkbox. In case any overlapping dates between the employees then I need to highlight the overlap, Column has red color in cells and also, I need the pop up message for overlap dates.

Else

If no any overlap, then pop up messages says like “there is no overlap between selecting employees”.
Finally I need the results to find the overlap dates to highlight so , forums experts if u have any suggestion or idea to solve this problem It will most great help for me. In case u need any more information on this problem to solve. Please let me know
Many sites and Google I searched I could find the correct solution for this but if solved many of them looking similar to find easy method for leave plan for overlap dates.

http://www.excelfox.com/forum/showth...ap-using-(vba)

Pls refer the updated attachment to find for solution.