You need a function to coun t the colour, like the one at
http://www.xldynamic.com/source/xld.ColourCounter.html

and then combine this with the text test like so,

=SUMPRODUCT(--(A1:A100="sold"),--(ColorIndex(A1:A100)=3))

to test for red solds.


--
HTH

Bob Phillips

"Jo Davis" wrote in message
...
Hi

Can you use the count if formula to say:

count how many cells say "sold" in blue text and how many say it in green
text?