I couldn't find an answer that seemed to work for me. I have a range of cells containing strings that need to be highlighted green based on if the last character of the string contains a "®" symbol (Alt+0174 on the number pad).
The data is on Sheet1 in the range A2:A & LR where "LR" is the variable last row of data. The last row can be as high as 600,000 so looping through the range the usual way takes longer than I'd like it to.
Is there a way to loop through using an array instead? I use Windows 7 and Excel 2010 btw.
Thank you in advance for your help!
Bookmarks