Sum Cells with text in red by condicional formating

[Blue_Wings]

Hi, I have the following formula working, summing cells based in font color "red" that for this example is the number "255"

But if the font color is based in a conditional formatting, the function doesn´t sum anything,

I guess its assuming that there are no cells with red color, how can I make it work?

Example in attach that should sum all the numbers in red: 5+6+7+8+9+10= 45


thanks.

Function SumRed(MyRange As Range)

For Each cell In MyRange
        If cell.Font.Color = 255 Then
            SumRed = SumRed + cell.Value
        End If
    Next cell

End Function

[:) Sixthsense :)]

Simple if you use the CF condition in formula.

In D1 Cell

=COUNTIF(A1:A10,">5")

[Blue_Wings]

Sixthsense

Thnaks for the help.

The conditional formatting that I have is more complex, the ">5", that was just an example to understand why the function does not work.

Its possible to sum cells taking in consideration the color gerated by the condicional formating?

[dangelor]

Possibly...

Function SumRed(MyRange As Range)
    
    For Each cell In MyRange
        If cell.FormatConditions.Item(1).Interior.Color = 255 Then
            If cell.DisplayFormat.Interior.Color = 255 Then
                SumRed = SumRed + cell.Value
            End If
        End If
    Next cell
    
End Function

[Blue_Wings]

dangelor doesn´t work, but thanks anyway

[Fluff13]

You cannot detect CF colour using a UDF.
You either need a macro, or use the CF rules to create a formula.