Ref. Attached file TEXT.XLSX
I have two columns of data. I want to highlight cells if their last five digits are found in another column.
ie. if cell "B" entry is 23658, and A1 is 10000023658, Cell A1's color should be highlighted.
How to do this? Thanks in advance.
Bookmarks