Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Duplicates in different colors from 2 tables

  Asked By: Bogart    Date: Feb 09    Category: MS Office    Views: 751
  

I have two tables. I want a function to identify the duplicates and
change the colour automatically.

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Cambria Lopez     Answered On: Feb 09

You don't need VBA for this, just conditional formatting. Let's say
table 1 is A1:A100 and table 2 is B1:B50. Highlight all of table 1 (From
B1 to B50) and go to the conditional formatting dialogue. Change it from
cell based to formula based and enter the formula:

=COUNTIF($A$1:$A$100,B1)>0

Then choose what formatting you want.

 
Didn't find what you were looking for? Find more on Duplicates in different colors from 2 tables Or get search suggestion and latest updates.




Tagged: