Maki,

You can use this UDF next to your data:

Function GetCellColor(r as range) as Integer
GetCellColor = r.font.colorindex
End Function

Now, next to A1 you can enter the formula:

=getcellcolor(A1)

Red is 3, Blue is 5.

You can then count red cells with a formula like:
=COUNTIF(B:B,3)

HTH
Kostis Vezerides


On 15 Μάϊος, 01:46, alligatormaki
wrote:
I have a column with cells that have text of different colors. Â*I'm trying to
count up the number of cells that the text is formatted a particular color. Â*
For example, A1 and A4 are formatted red text, while A2, A3, and A5 are
formatted blue text. Â*I need it to tell me that there are 2 cells with red
and 3 cells with blue. Â*Thanks.