Basically I have a list of people from A2:A1475 who report into people in
N2:N1475.

I need to highlight everyone in column A who is duplicated in column N but
do not report into themselves, so when row A and N don't match.

I'm guessing I have to use conditional formatting but I really need help
with it.

Many thanks in advance

Sam.D