Macro : Remove Green Color After Run Macro in Second

[muhammad susanto]

hi all..

i have code to filling mark "V" if cell contains background green color..
i want only the green color background is gone after i run macro in second...
how to make it in macro :

Sub Checklist_V()Dim cell As Range
Application.ScreenUpdating = False
With ActiveSheet
    For Each cell In .UsedRange
        If cell.Interior.ColorIndex = "14" Then cell.Value = "V"
    Next cell
End With
Application.ScreenUpdating = True
End Sub

any helps much appreciated...

 

[muhammad susanto]

Does my code work if you run it separately by itself?

hi Rick, I have do what your suggestion but there'is no change anything..