I am looking for something specific, so I am going to try what I’m struggling with.

I currently want to create an auto-generating timetable for a class schedule. I have three tables, two of then in a single spreadsheet, and the 3rd is on a different one. Table 3 from spreadsheet 2 contains two columns: course titles and their representative course codes. Table 2 is where I want to input the course codes (e.g., A01, A02, etc.) which will highlight certain cells in Table 1 to represent the time. In the end, I imagine it to look something like the image below. Only, I don’t know what formulas to use to connect the three tables, since conditional formatting doesn’t work when I try it. 

​I am looking for something specific, so I am going to try what I’m struggling with. I currently want to create an auto-generating timetable for a class schedule. I have three tables, two of then in a single spreadsheet, and the 3rd is on a different one. Table 3 from spreadsheet 2 contains two columns: course titles and their representative course codes. Table 2 is where I want to input the course codes (e.g., A01, A02, etc.) which will highlight certain cells in Table 1 to represent the time. In the end, I imagine it to look something like the image below. Only, I don’t know what formulas to use to connect the three tables, since conditional formatting doesn’t work when I try it.     Read More

​