Conditional formatting based on multiple criteria

[Tigerexcel]

Am struggling to get this to work:

Book8
	A	B	C	D	E	F	G	H	I
1		Wk 1	Wk 2	Wk 3	Wk 4	Wk 5	Wk 6	Wk 7	Wk 8
2	Jack
3	Tom
4	Pete
5	Sally
6
7			Jack	Wk 2	Wk 5			Jack	Wk 3
8			Tom	Wk 1	Wk 6			Tom	Wk 5
9			Pete	Wk 2				Pete	Wk 4
10			Sally	Wk 4	Wk 7	Wk 8		Sally
11
12				Desired result
13		Wk 1	Wk 2	Wk 3	Wk 4	Wk 5	Wk 6	Wk 7	Wk 8
14	Jack
15	Tom
16	Pete
17	Sally
Sheet1

I need formulae to automate the colouring of cells according to what is typed in rows 7 to 10. Jack is unavailable in Weeks 2 and 5 and is therefore declared a red etc. The second mini table in columns H to I are the weeks when staff are available and coloured brown.