![]()
Sub format_html() Dim alt_answer(5) xRow = 4 Do Until xRow >= Range("A65536").End(xlUp).Row tilde_text = Cells(xRow - 2, 1).Value amper_text = Cells(xRow - 1, 1).Value For x = 0 To 4 a = Split(Cells(xRow + x, 1).Value, ".") search_val = Trim(a(1)) replace_val = "<font color = " & Chr(34) & "#008000" & Chr(34) & ">" & search_val & "</font>" tilde_text = Replace(tilde_text, search_val, replace_val) amper_text = Replace(amper_text, search_val, replace_val) Next x Cells(xRow - 2, 1).Value = tilde_text Cells(xRow - 1, 1).Value = amper_text xRow = xRow + 9 Loop End Sub
Bookmarks