Highlight Overlap dates

[DocAElstein]

Results for code described in last Post. ( I have not done everything you wanted )
( Code is here: http://www.excelfox.com/forum/showth...0178#post10178 )

I have not checked the code extensively. I have not done everything you wanted.
I suggest you go through very carefully and try to understand the code and check and / or modify it to suit exactly what you want.

_.......
I did a quick test on your given data.

This was your given data:

Using Excel 2007 32 bit

Row\Col	AS	AT
7	Check Overlap dates	Employee names
8	WAHR	employee01
9	FALSCH	employee02
10	FALSCH	employee03
11	WAHR	employee04

Worksheet: Sheet1


OverLaptestData.JPG http://imgur.com/aHNfebY
OverLaptestData.jpg

Using Excel 2007 32 bit

Row\Col	B	C	D	E
18	Employee Names	From	To	OVER LAP Dates
19
20
21	employee01	02. Jan 17	15. Jan 17
22	employee03	03. Feb 17	10. Feb 17
23	employee04	10. Jan 17	20. Jan 17
24	employee04	04. Feb 17	10. Feb 17
25	employee02	01. Mrz 17	05. Mrz 17
26	employee04	03. Mrz 17	10. Mrz 17

Worksheet: Sheet1



Here is the results after running my code:( Check boxes checked in AS8 and AS11 to make cell value TRUE . Range object "behind" the cells has that entry pseudo as Range object and the True held As a Boolean , ...)

Using Excel 2007 32 bit

Row\Col	B	C	D	E
18	Employee Names	From	To	OVER LAP Dates
19
20
21	employee01	02. Jan 17	15. Jan 17
22	employee03	03. Feb 17	10. Feb 17
23	employee04	10. Jan 17	20. Jan 17
24	employee04	04. Feb 17	10. Feb 17
25	employee02	01. Mrz 17	05. Mrz 17
26	employee04	03. Mrz 17	10. Mrz 17

Worksheet: Sheet1


And Message Box:
MsgBoxOverlaps.JPG http://imgur.com/3XX7PKT
MsgBoxOverlaps.JPG