creating a calender

[jquerry]

I am looking for some advice on creating a calender in excel that will read text dates in a spreadsheet and then transpose them into a calender. For example corporate has provided a list of 200+ employees by name and the corresponding vacation request days (see below for format). I would like for another spreadsheet in another tab to apply those dates into a calender and then have a conditional format for overlapping dates to change color.[TABLE="width: 667"]
<colgroup><col style="width: 192pt; mso-width-source: userset; mso-width-alt: 9362;" width="256"> <col style="width: 46pt; mso-width-source: userset; mso-width-alt: 2230;" width="61"> <col style="width: 122pt; mso-width-source: userset; mso-width-alt: 5924;" width="162"> <col style="width: 76pt; mso-width-source: userset; mso-width-alt: 3693;" width="101"> <col style="width: 71pt; mso-width-source: userset; mso-width-alt: 3437;" width="94"> <col style="width: 77pt; mso-width-source: userset; mso-width-alt: 3766;" width="103"> <col style="width: 83pt; mso-width-source: userset; mso-width-alt: 4059;" width="111"> <tbody>[TR]
[TD="class: xl14489, width: 256, bgcolor: navy"]NAME (LAST,FIRST_MI)[/TD]
[TD="class: xl14490, width: 61, bgcolor: navy"]EMP ID[/TD]
[TD="class: xl14489, width: 162, bgcolor: navy"]LOCATION[/TD]
[TD="class: xl14489, width: 101, bgcolor: navy"]TDY LOCATION[/TD]
[TD="class: xl14489, width: 94, bgcolor: navy"]STATUS[/TD]
[TD="class: xl14491, width: 103, bgcolor: navy"]R&R DEPART (D/MM/YR)[/TD]
[TD="class: xl14491, width: 111, bgcolor: navy"]R&R RETURN (D/MM/YR)[/TD]
[/TR]
[TR]
[TD="class: xl14492, bgcolor: transparent"]Snuffy, Joe[/TD]
[TD="class: xl14492, bgcolor: transparent"][/TD]
[TD="class: xl14492, bgcolor: transparent"][/TD]
[TD="class: xl14492, bgcolor: transparent"] [/TD]
[TD="class: xl14492, bgcolor: transparent"][/TD]
[TD="class: xl14493, bgcolor: transparent"]25-Nov-13[/TD]
[TD="class: xl14493, bgcolor: transparent"]15-Dec-13[/TD]
[/TR]
</tbody>[/TABLE]

 

[Andrew Poulsom]

There's a Gantt Chart tutorial here:

Conditional Formatting in Excel | Chandoo.org - Learn Microsoft Excel Online

 

[Snakehips]

jquerry,

Maybe this small scale example will help you on your way..

I have included a marker whick you can use to show conflict within a given status. If that is not required then make the marker for all employees say H and it will highlight conflict regardless of status.

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1	Name	ID	Loc	TDY Loc	Status	Marker	Depart	Return		1-Jan	2-Jan	3-Jan	4-Jan	5-Jan	6-Jan	7-Jan	8-Jan	9-Jan	10-Jan
2	Snuffy, Joe				Supervisor	S	03/01/2013	05/01/2013				S	S	S
3	Smith, John				Office Wallah	OW	06/01/2013	08/01/2013							OW	OW	OW
4	Soap ,Joe				Office Wallah	OW	08/01/2013	09/01/2013									OW	OW
5	Contrary, Mary				Supervisor	S	01/01/2013	03/01/2013		S	S	S
6	Doe, Jane				Office Wallah	OW	03/01/2013	05/01/2013				OW	OW	OW
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
J2	1. / Formula is =AND(J$1>=$G2,J$1<=$H2)	Abc
J2	2. / Formula is =AND(J$1>=$G2,J$1<=$H2)	Abc

Hope that hgelps.