I am inexperienced with lookup functions, but was told that a lookup equation could be generated to compare the contents of "Column A" with contents of "Column B', and if there are matches, to change the cell format (color, font, etc) to show same values. Can anyone clue me in

Thanks in advance.