Search by Font Colour

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lamkelf@gmail.com - 15 Apr 2008 21:28 GMT

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!

Reply to this Message

JLGWhiz - 15 Apr 2008 21:42 GMT

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

> 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!

Reply to this Message

Dave Peterson - 15 Apr 2008 22:34 GMT

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

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

> 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!

Signature

Dave Peterson

Reply to this Message