Conditional Formatting --- "IF 0 in either of columns THEN..."

[PP3321]

I have 5 columns in my report

A, B, C, D, E

If there is 0 in 1 or more of these columns, then I want to format the entire row.

I add following formula in New Formatting Rule.
But it is not working.
Can anyone please help me...?

=$A$1:$E$1=0

 

[Jake Collins]

Dear PP3321

Use:

=COUNTIF(A1:E1,0)>=1

 

[Khalid NGO]

Hi,

Just a small change in Jake's formula:
=COUNTIF($A1:$E1,0)>=1

Another way is:
=OR($A1:$E1=0)

Regards,

 

[PP3321]

Thank youuuuuuuuuuuuuuuuu!