Using Lookup & Conditional Formating

piyo27

New Member
Joined
Jan 9, 2019
Messages
13
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
CourseStartEndDurationTraining Room
Course A01 Aug 201801 Aug 201812-01 APPLE
Course B15 Aug 201821 Aug 201852-02 ORANGE
Course A14 Aug 201814 Aug 201812-01 APPLE
Course C15 Aug 201817 Aug 201832-03 LEMON

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

Training Room Schedule Worksheet
Year:2018
Month:Aug
12345678910111213141516171819202122232425262728293031
WedThuFriSatSunMonTueWedThuFriSatSunMonTueWedThuFriSatSunMonTueWedThuFriSatSunMonTueWedThuFri
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
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

Watch MrExcel Video

Forum statistics

Threads
1,129,430
Messages
5,636,227
Members
416,908
Latest member
Streetsweeper

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top