Counting all cells with red font in Excel

[Zakynthos]

I want to COUNT (not sum) all the cells in a column that are formatted in RED.

What function/formula can I use for this?

 

[Mike H]

Counting or summing, have a look here:-

http://www.xldynamic.com/source/xld.ColourCounter.html#counting

Mike

 

[Zakynthos]

MIke,

Many thanks for your help, for the 2nd time today!