I have four columns of numbers.
Sometimes the numbers are > 0. . . sometimes they are all zeros. . . and sometimes they are blanks.
I want the conditional formatting of any one row to pick up on when all four cells have zeros, but ignore when they're blanks.
Any suggestions? When I use sum(A1:D1)=0 it also returns a true value for blanks.
Bookmarks