College Timeline

[kid1000002000]

Hi everyone!

I am attempting to map out my classes required for the next few years in order to obtain a college degree. Unfortunately, scheduling is a nightmare. What I want to do is have a list of classes that I need to take, and then paste a copy of those class names into a timeline. You can see what I mean by the example attached. For every class placed on the timeline, I would like the corresponding class in the list to change colors or something so I know I have scheduled it.

I know a lot about excel, though I am entirely inexperienced once you start to approach macros, etc. What are my options?