"You can simply conditionally format cells in that range to be white on
white if the cell equals zero"

How would I do this?

"markstro" wrote:

(Triple) wrote in message . com...
jtinne wrote in message ...
Here is my formula:
=COUNTIF(OFFSET('Daily MP'!$A:$A,0,MATCH(H$3,'Daily MP'!$5:$5,0)-1),"*" &
$B8 & "*")
When the total is zero, how do I show the cell as blank instead of having a
0 show in the cell?

You could click tools, then options, and under the view tab make sure
zero value is not checked/ticked. Of course this will be sheet wide,
so if by chance you do want a zero value to show other posts could be
best!

You can simply conditionally format cells in that range to be white on
white if the cell equals zero