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

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?

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.

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?

=GetColorCount(B2:B13,3)

Please Login or Register  to view this content.

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

Glad it helps you and thanks for the feedback and rep