Hello, this may be impossible, but I need a script that will change the color of new text entered in a cell. What I have right now changes the whole text color in the cell, I only need the specific text that was modified. This is what I have (the code was found in this forum by User: Palmetto) Any ideas?
Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("H8:L300")) Is Nothing Then
If Target.Font.ColorIndex = 5 Then
Target.Font.ColorIndex = 1
Else
Target.Font.ColorIndex = 5
End If
End If
End Sub
Bookmarks