Using Lookup & Conditional Formating

[piyo27]

Hi,

I have 2 worksheets - Course Entry worksheet and Training Room Schedule worksheet. For Course Entry worksheet, user updates data such as course title, duration, training room, etc. As for the Training Room Schedule, it shows a list of training rooms in a monthly calendar view. Once user update the training room for the course in the Course Entry, it will be marked in the Training Room Schedule. Besides coloring the cells, can it also reflect the course title and if there is a conflict can it reflect the course titles as well as marked the cell in another color?

Course Entry Worksheet

Course	Start	End	Duration	Training Room
Course A	01 Aug 2018	01 Aug 2018	1	2-01 APPLE
Course B	15 Aug 2018	21 Aug 2018	5	2-02 ORANGE
Course A	14 Aug 2018	14 Aug 2018	1	2-01 APPLE
Course C	15 Aug 2018	17 Aug 2018	3	2-03 LEMON

<colgroup><col><col span="2"><col><col></colgroup><tbody>
</tbody>

Training Room Schedule Worksheet

Year:	2018
Month:	Aug
	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31
	Wed	Thu	Fri	Sat	Sun	Mon	Tue	Wed	Thu	Fri	Sat	Sun	Mon	Tue	Wed	Thu	Fri	Sat	Sun	Mon	Tue	Wed	Thu	Fri	Sat	Sun	Mon	Tue	Wed	Thu	Fri
2-01 APPLE
2-02 ORANGE
2-03 LEMON

<colgroup><col><col span="9"><col><col span="4"><col><col><col span="15"></colgroup><tbody>
</tbody>

Thanks & Rgds