Google Sheets Use case
Highlight Duplicates Across Two Columns in Google Sheets (Conditional Formatting)
Highlight values that appear in both columns in Google Sheets with a COUNTIF custom formula. Covers one column, both columns, same row, missing values, case and spaces.