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 |
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) |