find to select cells filled in RED

  • Thread starter Thread starter William Poh Ben
  • Start date Start date
W

William Poh Ben

Can anyone help me how to find and select cells that are filled in RED
so that I can blank the red color off all at the same time ?

Any help is greatly appreciated.
many thanks !
 
Hi William,

Try something like this.

Sub RedBeGone()
Dim Cell As Range
For Each Cell In Range("Data")
If Cell.Interior.ColorIndex = 3 Then
Cell.Interior.ColorIndex = xlNone
End If
Next
End Sub

Where the range Data is a named range in your sheet which covers all the
cells that will be red.

HTH
Regards,
Howard
 
Howard,
This will also help me - thanks!

How do I find the list of the ColorIndex?

I'm looking or yello and want to change it to grey.

Thanks again,
Dave
 
Back
Top