Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
Sum in first blank cell and a few more things... | Excel Discussion (Misc queries) | |||
Making a particular cell or column required | Excel Discussion (Misc queries) | |||
How do I make a blank cell with a date format blank? | Excel Worksheet Functions | |||
COPY A CONCATENATE CELL TO BLANK CELL PUTTING IN THE NEXT BLANK C. | Excel Discussion (Misc queries) |