Search by Font Colour

[lamkelf]

Hi all,

I have a spreadsheet that someone updated by changing the font colour
from black to red. Is there a way that I can search cell by font
colour? Thanks a million!

 

[JLGWhiz]

Here is a basic loop to look for red font.
Dim c As Range
For Each c In Range("A1:Z20")
If c.Font.ColorIndex = 3 Then
'Do something
End If
Next

 

[Dave Peterson]

In newer versions of excel, you can search by formatting.

I _think_ it was added in xl2003 (or maybe xl2002????).