Counting Coloured Text

[Guest]

I was wondering if it’s possible to count different colours of text and
convert them into an amount.

Example

Red =1
Black = 0
Blue = .5

The cell range is from D9 to AK9

Any help would be appreciated.

 

[Guest]

try this site:
http://www.cpearson.com/excel/colors.htm