Formatting Query in Excel

[vksharma00001]

Hi Experts
I have a query related to formatting.
I have a data where some names are given
1. Vijay Kumar Sharma
2. Vikas Gupta
3. Dinesh Sharma

My requirement is Where excel find the word “Sharma” , it will change the format of text “Sharma” only to red colour. Output should be like this. I want the solution only by Excel.
1. Vijay Kumar Sharma
2. Vikas Gupta
3. Dinesh Sharma

 

[JoeMo]

Select all the cells with names in them, then run this macro.

Sub Sharma()
Dim c As Range, s As Long
Application.ScreenUpdating = False
For Each c In Selection
    s = InStr(c.Value, "Sharma")
    If s > 0 Then
        With c.Characters(s, Len("sharma"))
            .Font.Color = vbRed
        End With
    End If
Next c
Application.ScreenUpdating = True
End Sub

 

[ParamRay]

.
.

Try something like this:

Sub FontColor()
    
    Dim trng As Range
    Dim cell As Range
    Dim strg As String
    Dim leng As Byte
    Dim strt As Byte
    
    If TypeName(ActiveSheet) <> "Worksheet" Then Exit Sub
    
    strg = "Sharma"    'text for search
    leng = Len(strg)
    
    On Error Resume Next
    Set trng = ActiveSheet.Cells.SpecialCells( _
        xlCellTypeConstants, _
        xlTextValues)
    On Error GoTo 0
    
    If trng Is Nothing Then Exit Sub
    
    For Each cell In trng
        strt = InStr(LCase(cell.Value), LCase(strg))
        If strt <> 0 Then
            cell.Characters(Start:=strt, Length:=leng) _
                .Font.Color = RGB(255, 0, 0)
        End If
    Next cell

End Sub

 

[vksharma00001]

Hi Experts

Thank you all for replying. But i want the answer by excel. Is it possible by excel?

 

[ParamRay]

Hi Experts

Thank you all for replying. But i want the answer by excel. Is it possible by excel?

You could use conditional formatting, but it would apply the font colour to the entire cell...

 

[JoeMo]

Hi Experts

Thank you all for replying. But i want the answer by excel. Is it possible by excel?

Requires VBA for Excel which is what was provided in the responses to your post.