Search code examples
excelformattingexcel-formulaworksheet-functionconditional-formatting

Format if table value does not match first row

I have test results data in Excel like this:

Correct  d  b   c   a   b   c   d
Student1 d  b   c   a   b   c   d
Student2 d  b   c   a   b   c   a
Student3 d  b   c   a   b   d   d
Student4 d  d   c   a   b   c   a
Student5 d  d   c   a   b   c   d
Student6 d  b   c   a   b   b   d

I want to highlight the cells that contain incorrect answers.

How do I go about it?

Solution

  • The existing answer makes little sense to me hence an alternative:

    SO17703494 example