I am working on a master class-schedule for students in our school. Depending on their program (Medical, Dental, or Pharmacy), they are required to take some courses and not others.
Students names run down column A (A2:A11). Their program (Medical, Dental, Pharmacy) is listed next to their name in column B. All of the classes offered at the school are listed across row 1 (C1:R1).
Based on their respective program, I'd like to color gray, the cells of classes not required for each student. Is there a way, short of manually formatting each cell in the row?
Thanks. (see the screen shot -for a sample)
Bookmarks