Thread: Classify by textcolour?

I have a column with black and red text. I want to remove all occurences of red text (the entire row). Is that possible?

B

Hi,

You can adjust the following macro to your specifics ...

Sub Macro1()
Dim c As Range
For Each c In ActiveSheet.Range("A1:K12")
If c.Font.ColorIndex = 3 Then
c.Font.ColorIndex = 0
End If
Next c
End Sub

HTH

Hello campbell1

Your post does not comply with Rule 2 of our Forum RULES.

Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.