How to highlight duplicates between two columns?

7
votes

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.

1
google-sheets
You should show your code (your attempt to do it for yourself). – VorganHaze

1 Answers

18
votes

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)