Results 1 to 10 of 10

How can I make a cell "transparent" if a formula is FALSE?

Threaded View

  1. #1
    Registered User
    Join Date
    12-31-2009
    Location
    US
    MS-Off Ver
    Excel 2002
    Posts
    5

    Thumbs up How can I make a cell "transparent" if a formula is FALSE?

    A1 says "This sentence is too long", B1 has a formula.
    When B1 is true, A1 is blank.
    B1 has =IF(A2="Yes", 1, "")

    My problem is, when B1 is false, it displays like this:
    | This sentence is |___________|
    ( ____ being a blank B1)

    If B1 is false, I would like it to continue to display the contents of A1 through B1, the way it would if B1 was completely blank. For the cell to be "transparent"

    I guess my IF statement is returning "", which excel interprets as data. How can I make this work?

    (changing cell widths is not an option, maybe changing the IF statement? conditional formatting?)

    I'm using excel 2002. Thanks for your help!
    Last edited by ihavenoidea; 01-04-2010 at 11:08 PM. Reason: SOLVED

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