Counting Coloured Text

K

Killer

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.
 
Top