Comparing values in two columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I have two columns (Col A and Col B) having the employee numbers.
I want to compare the numbers in both the columns and highlight the
duplicate entries in Col A. Can you help?

Regards,
P Hamsa
 
Put this in B1 as cond.format and copy format down
=IF(COUNTIF($A$1:$A$100,B1)>=1,B1:$B$100,"")


"P.hamsa" skrev:
 
Highlight your range in Column A

Conditional Formatting
=COUNTIF($B$1:$B$100,$A1)>0

Adjust range to suit
format any color you like
 
Back
Top