how to assign conditional values to cells from selecting a item from a dropdown list?

Hello all,

I am not sure if this has already been addressed and if it has can you please let me know where I can go to find the answer. I am trying to set up a workbook to keep track of all the required training for all of the members in my work center. I have a fairly large work center of 40 members and a list of 35 courses that need to be completed in 12 Month, 36 Month or 48 Month intervals. In the workbook I would like to haves a drop down list in column “C” that that will let me choose either 12,36 or 48 months. That part is fairly simple; but here is what I am having a problem with (and I am not even sure if this is something that is able to be done in excel, but ...) I would like to be able to select the required training interval to for particular training course, and have that selected interval automatically assign a set of conditional values to all of the cells that are in the same row so that those cells will automatically change color from green to yellow to red depending on the date the member completed their training and the remaining time allotted for that particular training course. Any help would be greatly appreciated.

Thank you