Hello again,

I thank everyone for all the help and coding you've done for me!

Example111.xlsm

I have attached a workbook. Anne Beal on sheet1 has a different address on sheet2 - I'm looking to have a macro that compares what's on sheet1 to sheet2. What I wanted to know was, how do I program a macro where ONLY the text of "470th" of Anne Beal's address on sheet1 is highlighted red, rather than the whole cell being highlighted red?

Thanks in advance!
JB