I have data in the A
and B
column. B
column's data is mostly duplicates of A
's data, but not always. For example:
A
Budapest
Prague
Paris
Bukarest
Moscow
Rome
New York
B
Budapest
Prague
Los Angeles
Bukarest
I need to search the A
column if the values in B
exists there. If a row matches, I need to change the row's background colour in A
to red or something.
What function do I need to use, and how?
Sorry, I'm a newbie in Excel.