Forum Discussion

wyl_sl's avatar
wyl_sl
Copper Contributor
Apr 07, 2018

Conditional formatting equation difficulty

Hello,

 

I'd like to create a formula determining which cells to format:

 

Sheet1ColumnA is a series of names.

Sheet2ColumnA has more names, some which match Sheet1ColumnA.

Sheet2ColumnA also has duplicates which have differing addresses (ColumnE).

 

I want to highlight (fill cell w/ a color) rows in Sheet1ColumnA which match duplicate rows in Sheet2ColumnA & then apply the formula as a macro to be used monthly. I believe I can do this if I use a new Conditional Formatting rule with the proper formula encapsulating the conditions above.

 

I hope that makes sense.

 

Another way I've tried to explain it to myself is IF Sheet1ColumnA matches Sheet2ColumnA AND Sheet2ColumnA = Duplicates THEN format as so.

 

Thank you

  • Hi Shayon,

     

    You may use Conditional formatting rule

    =COUNTIF(Sheet2!$A:$A,$A1)>1

    on your column A in Sheet1 

     

Resources