Conditional Formatting Using AND

[paulrh]

Conditional formatting continues to haunt me!

I want to highlight a cell (G2) if it meets two criteria:

It (G2) has a value of zero
AND
the sum of columns D2,E2 and F2 is greater than zero

I have used the formula:

=AND((G2=0),SUM(D2:F2>0))

but this does not work!

Any ideas to solve this simple but annoying problem? Thanks.

 

[Tetra201]

Maybe:

=AND((G2=0),SUM(D2:F2)>0)

 

[paulrh]

What a dope I am!

Thank you so much

 

[Tetra201]

Glad to have helped.

 

[FDibbins]

Don't really need the () around the 1st part...
=AND((G2=0),SUM(D2:F2)>0)
could be just
=AND(G2=0,SUM(D2:F2)>0)