Conditional formatting on 4 cells in row

[AdRock]

I have 4 columns of numbers.

A1 B1 C1 D1
1 0 0 0
2 0 2 0
0 0 1 0
0 4 0 4
0 3 0 0
0 0 0 5

Some of the rows have 1 positive number and 3 zeros, some will have 2 positive numbers and 2 zeros.

Is there a way I can do conditional formatting or something that highlights any row which only has 1 positive number? It doesn't matter which cell in the row it's in but as long as the other 3 cells have zeros.

 

[Weaver]

Try the following

Use 'formula is'

=COUNTIF($A1:$D1,">0")=1

Ensure you selected A1 first when selecting range as you might get unexpected results otherwise.

HTH

 

[anandvarma]

try this formula

=OR(A1=B1,B1=C1,C1=D1)