How can I highlight duplicates from 2 rows using set criteria
Maybe this suffices
Select A2:A1475 (A2 active), then apply CF using Formula Is:
=COUNTIF($N:$N,A2)
Format to taste, ok out
--
Max
Singapore
---
"Sam.D" wrote:
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
|