(Another) Conditional Formatting Query

[dshilan]

Hi,

Background: I have a spreadsheet that compares data from two systems to check for differences, it often brings up 0 values, which get highlighted in yellow

Cells M:P will often be :
M N O P
0.00 0 0.00 0

I know I can apply conditional formatting thus: =$M3:$P3=0 and all will turn yellow, if the total is zero.

But when I copy this down all empty cells also become yellow, is there a way to avoid this,
I know it is a purely cosmetic issue, but would like to know how to resolve it.

Have attached edited example.

Thanks,

Dan

[NBVC]

How about?

=AND(M3<>"",M3=0)

If you select M3 to P3 and apply the above, then it will auto update to the relative cell reference it is in, then you can copy down the formatting.

Or you can preselect the entire range starting at topleft with M3 and apply the conditional formula above.