Count how many red colour font text or numeric in a column

[PRADEEPB270]

Is there any excel formula to know the exact result that how many red colour font text or numeric in a column?

Have a look for an example:-

AFG
1589CRD
SGD
125LGR
DRT258

The answer should be 3.Is there any excel formula?

[:) Sixthsense :)]

Two Options from my end

Manual and Auto

Manual - Put Autofilter and in Filter Selection Use Filter By Color option.
Auto - You have to go for UDF (VBA) solution. Please confirm whether you need UDF for this.

[PRADEEPB270]

OK Sir.Please provide the automation working for the solution.Suppose,my datas is in 'Col.D'and want to count the how many red colour font text or numeric datas exist?

[:) Sixthsense :)]

=GetColorCount(B2:B13,3)

Please Login or Register  to view this content.

[PRADEEPB270]

Thank you sir.Glad..................to find the nice solution.

[:) Sixthsense :)]

Glad it helps you and thanks for the feedback and rep