Please, help me. I have fill color into cells used conditional formatting. But I can't delete the content using VBA below:
But if I input the color manually it can finds the color index and clears the content.Sub CCVALUES() Range("G1:AK500").Select For Each Cell In Selection If Cell.Interior.ColorIndex = 15 Then Cell.ClearContents End If Next End Sub
Bookmarks