i have applied this below vba to highlight cell color based on cell value (Pending) it's working when i am typing Pending in cell value of Column C Range & here i have created a drop down list with text Pending in Column C Range & when i selected Pending from drop down then the cell is not highlighting
VBA Code:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim rCell As Range
With Sheet1
For Each rCell In Range("C1:C100")
If rCell.Value = "Pending" Then
rCell.Interior.Color = vbRed
Else
rCell.Interior.Color = xlNone
End If
Next
End With
End Sub