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: 730

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



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:


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.