+ Reply to Thread
Results 1 to 4 of 4

Re: make cell show blank when total is zero

  1. #1
    Bob L
    Guest

    Re: 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:

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


  2. #2
    Registered User
    Join Date
    11-21-2005
    Posts
    32
    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.
    I don't pretend to know what i'm doing and i'm not about to start

  3. #3
    Forum Expert swatsp0p's Avatar
    Join Date
    10-07-2004
    Location
    Kentucky, USA
    MS-Off Ver
    Excel 2010
    Posts
    1,545
    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
    Bruce
    The older I get, the better I used to be.
    USA

  4. #4
    Forum Expert swatsp0p's Avatar
    Join Date
    10-07-2004
    Location
    Kentucky, USA
    MS-Off Ver
    Excel 2010
    Posts
    1,545
    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1