China Naming Network - Ziwei Dou Shu - Excel invigilator arrangement table, densely packed with invigilators' names. How can I know all the invigilation arrangements of a teacher quickly and accurately?

Excel invigilator arrangement table, densely packed with invigilators' names. How can I know all the invigilation arrangements of a teacher quickly and accurately?

Find an empty cell (such as K 1) outside the invigilation schedule and fill in the name of the teacher to be inquired.

Suppose the teacher's name area in your invigilation arrangement is A2:H40.

Starting with A2, select A2:H40.

Conditional Formatting

Use the formula to determine the cell to set.

Conditional formula

=a2=$K$ 1

Also set the cell fill shading.

Do it.