Hi colin,

select A1:D7 = CF = Formula:
=COUNTIF($A1:$D1,0)1

sorry, have a typo in the formula above.

=COUNTIF($A1:$D1,0)0


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2