Hi Colin,

Am Thu, 31 May 2012 18:02:17 +0100 schrieb Colin Hayes:

Is it possible do you know to have it apply only for rows which have two
0.00 values?

if you want to apply it for rows with exact two 0.00 values:
=COUNTIF($A1:$D1,0)=2
But if you want to apply it for rows with two or more 0.00 values:
=COUNTIF($A1:$D1,0)=2


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