Using function based on "Font Color"
Thank you very much for your answer but unfortunately I am not so good in this
I need more help
If I have A1 = 7 (red colour), A2 =5 (green colour), A3 = 4 (lime colour),
A4 = 2 (green colour), A5 =6 (red colour), A6 =2 (red colour) etc
what can I use to have (a) the sum of red colour cells and (b) the count of
green colour cells?
thank you
--
Best regards
danai_mp
Ο χρήστης "Bob Phillips" *γγραψε:
Function CountCells(rng As Range, ci As Long)
For each cell in rng
If cell.Font.Colorindex = ci then
CountCells = CountCells +1
End If
Next cell
End Function
=CountCells(A1:B10,3)
--
__________________________________
HTH
Bob
"danai_mp" wrote in message
...
Could you please inform me if there is a function which can count and/or
summarize cells in excel based on "Font Color"
|