make cell show blank when total is zero
 

"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

make cell show blank when total is zero
 

Go to Format on the tool bar, select conditional formatting. Select cell
value is 'equal to' and then type 0 in the next box. Then select the
format box and seT the text colour to white. Then if your formula
returns 0 the cell will appear blank.


--
penri0_0


------------------------------------------------------------------------
penri0_0's Profile: http://www.excelforum.com/member.php...o&userid=28947
View this thread: http://www.excelforum.com/showthread...hreadid=543743

make cell show blank when total is zero
 

I think what the OP want to do is return a blank cell rather than 'hide'
the result with text color.

Alter your formula to this:

=IF(COUNTIF(OFFSET('Daily MP'!$A:$A,0,MATCH(H$3,'Daily
MP'!$5:$5,0)-1),"*" &$B8 & "*")=0,"",COUNTIF(OFFSET('Daily
MP'!$A:$A,0,MATCH(H$3,'Daily MP'!$5:$5,0)-1),"*" &$B8 & "*"))

should the result of your formula be zero, a blank cell will be the
result, otherwise the result will be shown.

Is this what you were looking for?

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=543743

make cell show blank when total is zero
 

I think what the OP want to do is return a blank cell rather than 'hide'
the result with text color.

Alter your formula to this:

=IF(COUNTIF(OFFSET('Daily MP'!$A:$A,0,MATCH(H$3,'Daily
MP'!$5:$5,0)-1),"*" &$B8 & "*")=0,"",COUNTIF(OFFSET('Daily
MP'!$A:$A,0,MATCH(H$3,'Daily MP'!$5:$5,0)-1),"*" &$B8 & "*"))

should the result of your formula be zero, a blank cell will be the
result, otherwise the result will be shown.

Is this what you were looking for?

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=543743