I have two tabs in a Spreadsheet. Both are having a list of data. I want to highlight cells in one tab that match with cells from another tab.
Column 1 ABC XYZ PQR DEF
Column 1 DEF PQR
Here, I want DEF and PQR to get highlighted in Tab 1 data.
How can I do this?