Hi Friends,
I have amended the code but it's for columns. I want this formatting for entire row 4 only and not for columns. Because it's disturbing my program if there is any data using ':' sign then the same formatting is applied which I don't want.
Sub BoldText()
Dim x As Long
Dim rngCell As Range
Range("G4").FormulaR1C1 = _
"=IF(Information!R[3]C[6]="""","""",""Name of the student: ""& Information!R[3]C[6])"
If Not Intersect(ActiveCell, Columns("a:r")) Is Nothing Then
For Each rngCell In Cells(ActiveCell.Row, "A").Resize(, 18).Cells
With rngCell
If .Value Like "*[:]*" Then
If .HasFormula Then .Formula = .Value
.Characters.Font.Bold = True
x = InStr(.Value, ":")
.Characters(x).Font.Bold = False
End If
End With
Next rngCell
End If
MsgBox "Done!", 64
End Sub
The ':' sign is not changing to bold. I want to bold ':' sign too.
Will you now please amend the code for entire row 4?
Any help will be appreciated.
Thanking you.
Bookmarks