Vacation calendar

[wiwchar]

I keep track of my employee's vacations on a spreadsheet. At times, I need to update various days where the office is closed. These can be statuatory holidays or company days. Some days the employees vacation allotment is not decremented. These I need to shade the cell with a colour. There are days where the office is closed and all employees need to take a vacation day. In these cells, I would put in a 1 to decrement the vacation days by one. Below is just a part of the spreadsheet. How can this be done rather than manually for each individual employee?

QA Vacation Schedule 2007.xls
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
3	EMPLOYEE			JANUARY					FEBRUARY				MARCH				APRIL
4	NAME & INFO			1	8	15	22	29	5	12	19	26	4	11	18	25	1	8	15	22
5
6		DAYS LEFT AT END OF PREVIOUS YEAR
7			M
8	Andres, Conrad	0	T
9		VACATION DAYS AT ANNIVERSARY	W
10	November 24, 2003		T
11		15	F
12		ENTITLEMENT
13		REMAINING		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
2007

 

[wiwchar]

Also, let me add some clarification. If Jan 2 is in D8 for Conrad, it will be in D16 for Terry, D24 for Allan and so on.