I have the table in Excel:

  A    B        C
    12   Novak    Bern
    73   Bayda    Frankfurt
    1    Schmidt  Koln
    12   Novak    Bern
    9    Beckhan  Paris
    11   Youd     Warsaw
    73   Dosed    Kiev
I'd like find and highlight all rows which: -value in column "A" are the same (duplicate values) like: Cells(2,1) And Cells(7,1) - AND corresponding them value in column "C" are NOT the same

How can I do that.