Excel 97
I have a schedule in which various operators are assigned in pairs to
operate certain equipment. Because of safety issues, trainees must work with
certified operators, so two trainees cannot be paired on the same machine on
the same shift.

My schedule has the employees listed down the first column, and the days of
the week are in columns B:H. Operator qualifications (C for certified, T for
trainee) are in a separate column off to
the right. Machine assignments are listed in the columns by day to the right
of the employees' names. Machines are designated by unique shop names such
as North, Central, South etc.

I'm looking for a way to format the cells containing the assignments (the
ones with the machine designations) to flag if two trainees are
inadvertently scheduled to the same machine on the same shift. I have a
simplified example of the schedule below.

I'm wondering if a SUMIF function combined with conditional formatting would
do it, but I'm having trouble putting it together.
Any help is much appreciated, as always.

EMPL. MON TUE WED ... QUAL
Adam North South
C
Betty South Central
C
Charlie North South
T
Donna South North T
Eddie Central North
T
Fran Central Central
T

In this case above, the assigned machine "Central" for Eddie and
Fran on Monday should meet the condition and be flagged in a particular
format. Tuesday's assignments would flag both "North" assignments, etc.

Again, any help would be appreciated and thanks in advance.