+ Reply to Thread
Results 1 to 5 of 5

How to show and hide cell content?

  1. #1
    Forum Contributor
    Join Date
    03-04-2015
    Location
    Jakarta
    MS-Off Ver
    15
    Posts
    154

    How to show and hide cell content?

    How to show cell content and hide cell content? If cell B3 there is a content, the content of cell A3 will be shown. If B3 is empty so the content of A3 will be hidden.

  2. #2
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: How to show and hide cell content?

    Try this

    =IF(B3<>"",A3,"")
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  3. #3
    Forum Contributor
    Join Date
    03-04-2015
    Location
    Jakarta
    MS-Off Ver
    15
    Posts
    154

    Re: How to show and hide cell content?

    where should I input the formula?

  4. #4
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: How to show and hide cell content?

    Well, since you reference two cells, the formula should be written in and any cell other than A3 or B3.

    Let's say C3

    Row\Col
    A
    B
    C
    3
    5
    1
    5

  5. #5
    Forum Contributor
    Join Date
    03-04-2015
    Location
    Jakarta
    MS-Off Ver
    15
    Posts
    154

    Re: How to show and hide cell content?

    thanks so much, problem solved.

+ 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. Hide rows with same content in cell
    By henk400 in forum Excel General
    Replies: 1
    Last Post: 03-30-2015, 08:11 AM
  2. [SOLVED] Content Control Checkbox Hide and Show Text
    By schmidt1962 in forum Word Programming / VBA / Macros
    Replies: 7
    Last Post: 10-31-2014, 11:10 PM
  3. Hide cell content
    By tony10speed in forum Excel General
    Replies: 5
    Last Post: 01-26-2014, 05:14 PM
  4. How to show only some content of a cell?
    By MayaCU in forum Excel General
    Replies: 2
    Last Post: 12-14-2011, 07:05 AM
  5. show content of particular cell
    By lex_ce in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-09-2009, 05:53 AM

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