Solved Change color to a portion of a text in excel

June 15, 2017 at 13:34:09
Specs: Windows 7
Need a formula or shortcut to color code the text (sum) in below cells and the characters ("No-", "Yes-","Do-") should not be color coded

No-Sum
Yes-Sum
Do-Sum


See More: Change color to a portion of a text in excel

Report •

#1
June 16, 2017 at 00:56:18
Ok so you need this, why not do it then?

or are you asking us to help you? in which case I would expect you to ASK and not just tell us what you want!!

Anyways it can be done with VBA - ask if you want help
probably with conditional formatting too but I cant help with that.


Report •

#2
June 16, 2017 at 05:31:41
✔ Best Answer
Anyways without knowing anything about your workbook I can only provide this solution

Dim Bcell As Range
Dim StartPos As Long

Sub CreateTable()
    
    For Each Bcell In Range("A1", Range("A" & Rows.Count).End(xlUp))
        
        StartPos = InStr(1, Bcell, "Sum")
        
        Bcell.Characters(Start:=StartPos, Length:=Len(Bcell)).Font.ColorIndex = 3
        
    Next Bcell

End Sub


Report •
Related Solutions


Ask Question