I apologize for breaching any netiquette rules, this is my first stab at posting in a forum. I did perform searches both internal and external of chandoo, but came up fruitless. The coding you provided is, by far, the closest I have gotten to a solution yet.
My excel sheet uses red to...
I want to build a macro to search my worksheet for Red text and replace the text with a line of code to link the text. Is there any way to find and replace text by color?