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)


+-------------------------------------------------------------------+
|Filename: ExcelTip1.jpg |
|Download: http://www.excelforum.com/attachment.php?postid=3659 |
+-------------------------------------------------------------------+

--
Rick_B
------------------------------------------------------------------------
Rick_B's Profile: http://www.excelforum.com/member.php...fo&userid=5964
View this thread: http://www.excelforum.com/showthread...hreadid=391380