Hi,

I want a formula to find duplicate values between two columns. In the following example Anna & Anna2 are require to get same color.

Col A Col B
Anna Anna2
Ann2 Anna3
Anna Anna4
Anna1 Anna3

Thanks
Anna