I think what the OP want to do is return a blank cell rather than 'hide'
the result with text color.

Alter your formula to this:

=IF(COUNTIF(OFFSET('Daily MP'!$A:$A,0,MATCH(H$3,'Daily
MP'!$5:$5,0)-1),"*" &$B8 & "*")=0,"",COUNTIF(OFFSET('Daily
MP'!$A:$A,0,MATCH(H$3,'Daily MP'!$5:$5,0)-1),"*" &$B8 & "*"))

should the result of your formula be zero, a blank cell will be the
result, otherwise the result will be shown.

Is this what you were looking for?

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=543743