Count number of cells with red font

[moppyau]

My name is Brett & I live in Melbourne Australia. I have a problem which I cannot solve but are quite sure many of you will find easy to solve. I have a spread sheet I use for golf results. I want to be able count cells that have red font for text. When I enter a win in column A it stays with black font but I have used conditional formatting so if I enter a draw in the same column it changes the font to red. I've tried all sorts of VBA & formula's but dont get the answer I'm after. Eg: A1 Draw (in red), A2 Won (in black) A3 Draw (in red) A4 Draw (in red). The answer I'm after is 3. (The total of red fonts) If anyone could help me it would be much appreciated. I a bit of a newbie at excel but find it facinating so be gentle on me. I've attached an example. Thanks again.

[:) Sixthsense :)]

In D1 Cell

Please Login or Register  to view this content.

[moppyau]

Thanks Sixthsense, your a genius. I knew somebody would be able to help. Thanks again Mate.

[:) Sixthsense :)]

Glad it helps you and thanks for the feedback