In article , Claus Busch
writes
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


Hi Claus

Excellent - thanks Claus. Works first time.



Best Wishes