Counting Coloured Text
 

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.

Counting Coloured Text
 

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

"Killer" wrote:

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.