+ Reply to Thread
Results 1 to 3 of 3

Hiding cells when the value of a cell is a certain number

  1. #1
    Registered User
    Join Date
    04-13-2009
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    8

    Hiding cells when the value of a cell is a certain number

    I want to be able to hide a selection of cells, including the border formatting, when another cell has a particular value (in this case I want the cells visible only if the value in the cell is above 0). I've looked around and can't seem to find anything relevant. Anyone got any ideas?
    Cheers.
    Last edited by shockerty; 05-07-2009 at 08:51 PM. Reason: [SOLVED]

  2. #2
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: Hiding cells when the value of a cell is a certain number

    Hi shockerty,

    One approach is to select the cells you want hidden, remove all regular formatting, then change the font colour to white.

    Now select "Format --> Conditional Formatting" (or whatever the path is for Excel 2007 to Conditional Formatting), and select Formula is: and use =$A$1>0 where A1 is the cell with your "particular value". Now set the conditional formatting to make the font colour automatic and the borders as you prefer. Click Okay.

    Cheers,
    Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.

  3. #3
    Registered User
    Join Date
    04-13-2009
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    8

    Smile Re: Hiding cells when the value of a cell is a certain number

    Ah yeah. Didn't think of that! Ha. Thanks very much!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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