I'm trying to highlight 2 cells when a particular name is in a column using conditional formatting. I have to use VBA code as I already have 3 other conditional statements. The code works other than when the name is removed or change, the color formatting remains. I want it to only be there when this text(name) is in the column. Here is my coding:
Private Sub Worksheet_Change(ByVal Target As Range)
Set MyPlage = Range("A1:T250")
For Each Cell In MyPlage
If Cell.Value = "Ken Ballard" Then
Range("A" + CStr(Cell.Row) + ":B" + CStr(Cell.Row)).Interior.ColorIndex = 43
End If
Next
End Sub
Any help would be appreciated! Thanks!
Bookmarks