"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:
> [email protected] (Triple) wrote in message news:<[email protected]>...
> > jtinne <[email protected]> wrote in message news:<[email protected]>...
> > > 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
>
Bookmarks