Another tough one: Find text, add text to cell with different color/font

[klarowe]

I want to try to create a macro that will search through column A on all sheets of my workbook for the text "Comments:". Then for each one that is found, add the text "Oxygen Cleaning Required" in bold, red font (colorindex = 3)... all within the same cell.

If that cannot be accomplished then I can unmerge the cells and put the new text (oxygen cleaning required) in column C of the same row as "comments:"

This will all be linked to either a button or upon workbook open, but if you can get me the bulk of the code, that will work.

Thanks yet again!!!

 

[MrKowz]

I'll have to give that a try when I can. (just got pulled off this project and put on another.. lol).
Thanks again for your help!!!

Not a problem, thanks for the feedback, and good luck!