Forum Discussion

1788-L's avatar
1788-L
Copper Contributor
Mar 14, 2019
Solved

Formulas & Conditional Formatting

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 ...
Conditional Formatting
excel
Formulas and Functions
  • ILikePi's avatar
    ILikePi
    Mar 14, 2019

    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

     

ILikePi's avatar
ILikePi
Copper Contributor
Mar 14, 2019

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