Google sheets doesn't have a preset conditional formatting for duplicate cells. I need to highlight the cells in column A and B that contains a match/duplicate between the two of them.
Compare Two Columns With a VLOOKUP Function and Find Matching Data. Another way to have Excel find duplicates in two columns is to use a VLOOKUP function. Excel will compare each cell in the second column against the cells in the first column. Use the =VLOOKUP(B2,$A$2:$A$14,1,0) for the column displaying the results.
Please clear formatting from ColumnsA:B, select ColumnA and Format, Conditional formatting..., Format cells if... Custom formula is and:
=countif(B:B,A1)
Then select fill of choice and Done.
Select ColumnB and repeat with:
=countif(A:A,B1)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With