Forum Discussion
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