I think Bernard meant:

=COUNTIF($A1$:G1,"~*~*~*")

(slightly different order. ~* will represent that asterisk character.)

On 05/15/2010 08:05, Bernard Liengme wrote:
Select all the data - I will assume each row foes fro A to G and that
the data starts on row 1
In the conditional formatting dialog use this formula
=COUNTIF($A1$:G1,"*~*~*~")
The ~ are needed to tell Excel not to treat * as a wildcard
best wishes