Formulas & Conditional Formatting

[1788-L]

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.

[#2 · Accepted solution]

Hi 

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