jonathynblythe
New member
- Joined
- Jul 5, 2011
- Messages
- 13
- Reaction score
- 0
- Points
- 0
Hello again,
I thank everyone for all the help and coding you've done for me!
View attachment 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
I thank everyone for all the help and coding you've done for me!
View attachment 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