How to clear content on the cell that has background color from conditional formatting?

**putritersenyum** · 05-18-2016, 06:52 AM

Please, help me. I have fill color into cells used conditional formatting. But I can't delete the content using VBA below:

Please Login or Register  to view this content.

But if I input the color manually it can finds the color index and clears the content.

**Mandeep Baluja** · 05-18-2016, 07:35 AM

Sub CCVALUES()

Range("G1:AK500").Select
For Each Cell In Selection
If Cell.Interior.ColorIndex = 15 Then
Cell.ClearContents
End If
Next
Application.ScreenUpdating = True

End Sub

**putritersenyum** · 05-18-2016, 09:13 AM

@ Mandeep Baluja
the problem is how to find the color set by Conditional Formatting?

**JOHN H. DAVIS** · 05-18-2016, 09:41 AM

Does this help?

http://stackoverflow.com/questions/7...ell-in-excel-2

http://www.excelfox.com/forum/showth...atting-or-not)

**putritersenyum** · 05-18-2016, 10:12 AM

the problem has been solved.

thanks JOHN H. DAVIS for the links.

**JOHN H. DAVIS** · 05-18-2016, 10:13 AM

You're welcome. Glad to help out.

How to clear content on the cell that has background color from conditional formatting?

LinkBack

Thread Tools

Rate This Thread

Display

How to clear content on the cell that has background color from conditional formatting?

Re: How to clear content on the cell that has background color from conditional formatting

Re: How to clear content on the cell that has background color from conditional formatting

Re: How to clear content on the cell that has background color from conditional formatting

Re: How to clear content on the cell that has background color from conditional formatting

Re: How to clear content on the cell that has background color from conditional formatting

Thread Information

Users Browsing this Thread

Similar Threads

Swapping cell content to INCLUDE CELL FORMATTING (Text color, background color, etc)

[SOLVED] Conditional Formatting Cell Background Color

[SOLVED] Conditional formatting to adapt font color to background color

To clear content if conditional formatting cell return gray color

How to keep a background color while using conditional formatting in the cell?

[SOLVED] Conditional Formatting, current cell color follows to diff cell based on content

Conditional cell background formatting, based on cell content

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions