I was wondering if its 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.