Mar 14 2019 08:59 AM
Hello Friends,
I need help with a formula or a form of conditional formatting that will cross reference data from my Customer column on Sheet1 with data on the Customer column on Sheet2. I can't seem to figure out how to have all the cells that are repeating customers between the two sheets to be highlighted on either sheet.
I am trying to cross reference data between two columns (located within separate sheets) and highlight the cells with duplicate values between the two columns.
Mar 14 2019 09:35 AM
SolutionHi
Name the ranges with that you wish to check for duplicates.
i.e. CustomersA, CustomersB
After naming the ranges highlight the column you wish to apply the conditional format.
For my example I am going to use the range C2:C1234
Use a formula as the basis I would say =COUNTIF(CustomersA,C2)+COUNTIF(CustomersB,C2) > 1
Then choose the highlighting you normally would.
Hopefully that gets you on the path
Mar 14 2019 09:35 AM
SolutionHi
Name the ranges with that you wish to check for duplicates.
i.e. CustomersA, CustomersB
After naming the ranges highlight the column you wish to apply the conditional format.
For my example I am going to use the range C2:C1234
Use a formula as the basis I would say =COUNTIF(CustomersA,C2)+COUNTIF(CustomersB,C2) > 1
Then choose the highlighting you normally would.
Hopefully that gets you on the path