+ Reply to Thread
Results 1 to 4 of 4

Hiding data

  1. #1
    Registered User
    Join Date
    06-06-2018
    Location
    New Jersey, USA
    MS-Off Ver
    2016
    Posts
    2

    Hiding data

    I would like to hide data (text) of a cell until adjacent cell is no longer blank. I tried to use =IF(ISBLANK) formula, but the cell shows #NAME?
    What am I doing wrong here?

  2. #2
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Re: Hiding data

    Good afternoon bcattell3

    Welcome to the forum!

    ISBLANK will return TRUE or FALSE depending on the state of the cell, so that is what you must test for, thus :
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    HTH

    DominicB

  3. #3
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    Re: Hiding data

    I thought maybe conditional formatting...
    in A2 (for example)
    go to conditional formatting >> new rule >> use a formula to determine which cells to format >> =B2="" then click the format button and under the font tab select color equal to white then OK, OK and Apply, it may revert the formula to ="B2="""" and if it does go back in and remove the extra quotes so it looks like above and it will then make cell A2's text or number white with a white cell color so it will "disappear" until something is populated in B2.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  4. #4
    Registered User
    Join Date
    06-06-2018
    Location
    New Jersey, USA
    MS-Off Ver
    2016
    Posts
    2

    Re: Hiding data

    Great, thanks, DominicB. It worked like a charm! I was missing the second set of quotes. Sambo, thanks, I might try conditional and see how that works, too.
    Last edited by bcattell3; 06-06-2018 at 09:59 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 8
    Last Post: 01-23-2015, 02:32 PM
  2. Hiding Sheets based on cell value, only hiding last sheet
    By mattblack2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-17-2014, 03:21 PM
  3. Hiding columns in excel without hiding form button
    By rename in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-01-2013, 01:38 AM
  4. Replies: 9
    Last Post: 09-19-2012, 05:31 AM
  5. Un-Hiding and Hiding Columns based on Drop-Down Values in a Column.
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 10-30-2011, 09:24 AM
  6. Un-Hiding and Hiding Columns based on Drop-Down Values in a Column.
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-11-2011, 06:49 AM
  7. Replies: 2
    Last Post: 10-18-2005, 10:05 PM

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