Hi,
How to adjust below code in order to highlight a cell (only in specific columns) when value is changed?
Private Sub WorkSheet_Change(ByVal Target As Range)
If Target.Value <> "" Then
Target.Interior.ColorIndex = 36
End If
End Sub
Thanks.
How to adjust below code in order to highlight a cell (only in specific columns) when value is changed?
Private Sub WorkSheet_Change(ByVal Target As Range)
If Target.Value <> "" Then
Target.Interior.ColorIndex = 36
End If
End Sub
Thanks.