Highlighting specific letters in a cell with different colours

Hi,

I am new to the forum, and am looking for advice and guidance on a method for highlighting specific letters and letter combinations in a cell with a large number of letters for scientific research. I have attached an example excel file for this. I am able to highlight words with a VBA, but wen there is a single cell with a large number of letters for example in B2 (ALGNGCTHMNSSJCDGJNACHSKDNHMJC) and when i am looking to highlight certain letters in the C column LIST (NG, NS, NA, NH) with different respective colours, I am unable to.

Is this even possible? Any advice or help would be greatly appreciated.

Many Thanks,

Joseph

Hi,

yes it's doable - just using the Macro Recorder ! - but in your attachment you forgot the desired colors in C2:C11 …

Hi,

Apologies, any colours are fine as long as they are different for each letter combination. Do you have an example macro for this that i can work with?

Many thanks,

Joseph

To start the VBA procedure is to just activate the Macro Recorder and operate manually.
For further help I just need an attachment with text colors in Range C2:C11 …

Hi,

would this do? or do you need vb colours?

Try

Please Login or Register  to view this content.

According to last attachment (only column C as per initial post) as a VBA beginner starter :

PHP Code: 

Sub Demo1()
             Dim Rg As Range, S&
    With [B2]
           .Font.ColorIndex = xlAutomatic
        For Each Rg In Range("C2", [C1].End(xlDown))
                  S = InStr(.Text, Rg.Text)
            While S
                 .Characters(S, Len(Rg.Text)).Font.ColorIndex = Rg.Font.ColorIndex
                  S = InStr(S + 1, .Text, Rg.Text)
            Wend
        Next
    End With
End Sub 


► Do you like it ? ► ► So thanks to click on bottom left star icon « ★ Add Reputation » ! ◄ ◄

Brilliant! It works perfectly! Thankyou!

You are welcome and thaks for the rep.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.