Check font color and return a True or False

**randolphoralph** · 11-24-2008, 04:18 PM

I am looking for a formula to return either True/False in Column J if the font color in Column H is Red.

Is there a formula that can do this?

**Shijesh Kumar** · 11-24-2008, 04:24 PM

Here is UDF for the same

Please Login or Register  to view this content.

Usage :--

=isRed(A1)

will return True if A1 is red else it will return false

**randolphoralph** · 11-24-2008, 04:38 PM

I entered the code provided into a UDF and it returns false on cells where the font color is red and black.

Did I do something wrong?

**Shijesh Kumar** · 11-24-2008, 05:35 PM

Have you created a new module and entered the code there or have u used sheet1/sheet2/sheet3 module..

**randolphoralph** · 11-24-2008, 05:39 PM

I entered a new Module under PERSONAL.xls

**Shijesh Kumar** · 11-24-2008, 05:44 PM

Hi,

I have attached a spreadsheet..See if this is what you want..
If any modification need tell me .. i will do that

If Red.. .it will be true else it will display false

**randolphoralph** · 11-24-2008, 05:48 PM

I see why it did not work.

I am trying to see if the color of the Font is Red.

Not the fill color.

Sorry for the confusion.

**Shijesh Kumar** · 11-24-2008, 06:18 PM

not a problem..

for font color the is code is almost similar

Please Login or Register  to view this content.

**randolphoralph** · 11-24-2008, 06:49 PM

Thanks a million!

**mccaheyw** · 06-20-2012, 10:03 AM

This code snipet worked better for me because the tested cell was made "red" based on a Conditional Format "Formula Is" script.

Function isRed(cell As Range) As String
If cell.Font.Color = red Then
isRed = "old"
Else
isRed = "Valid"
End If
End Function

Function isRed(cell As Range) As Boolean
If cell.Font.Color = red Then
isRed = True
Else
isRed = False
End If
End Function

**martyyy007** · 12-21-2013, 08:41 PM

Hi Guys!

I want to check if two font colours are equal (in an IF function), then ... do something

So if this cell's font colour = this cells font colour

How can i do that ?

**FDibbins** · 12-21-2013, 09:13 PM

martyy007 we3lcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.