Forum Discussion
wyl_sl
Apr 07, 2018Copper Contributor
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 h...
SergeiBaklan
Apr 07, 2018Diamond Contributor
Hi Shayon,
You may use Conditional formatting rule
=COUNTIF(Sheet2!$A:$A,$A1)>1
on your column A in Sheet1