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?