+ Reply to Thread
Results 1 to 5 of 5

hide cell values until you input information?

  1. 04-05-2007, 08:40 PM #1
    h2o_polo_boi
    h2o_polo_boi is offline
    Registered User
    Join Date
    04-05-2007
    Posts
    3

    hide cell values until you input information?

    Hey guys and girls. Is there a way to hide values in a cell until data has been inputted?

    For example, I have a cell with a formula that shows 00:00.70 until data is typed into corresponding cells. I don't want weird numbers like 00:00.70 to show with 0 values because they are distracting. Another cell shows #########.

    I never had this problem before because my formulas usually start off with 0 as the answer. Then I simply go to options and uncheck "show zero values."

    I'm stumped

    I have included a .pdf file to show you what I mean
    Attached Files Attached Files
    Last edited by h2o_polo_boi; 04-05-2007 at 08:45 PM.
    Reply With QuoteRegister To Reply
  2. 04-05-2007, 08:42 PM #2
    mikerickson
    mikerickson is offline
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229
    Use conditional formatting to give the ugly original values a font color white. When changed, the font color will be normal.
    Reply With QuoteRegister To Reply
  3. 04-05-2007, 08:48 PM #3
    h2o_polo_boi
    h2o_polo_boi is offline
    Registered User
    Join Date
    04-05-2007
    Posts
    3
    Quote Originally Posted by mikerickson
    Use conditional formatting to give the ugly original values a font color white. When changed, the font color will be normal.
    How would I do that? I'm kinda new to excel. All i know is to go to Format --> Conditional Formatting. Don't know the rest.
    Reply With QuoteRegister To Reply
  4. 04-05-2007, 08:52 PM #4
    mikerickson
    mikerickson is offline
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229
    The Cell Value is equal to your start value.
    Then press the format button, choose FONT from the top, select the color (middle of the right side).
    For testing, it would be best to choose light blue rather than white.
    Reply With QuoteRegister To Reply
  5. 04-05-2007, 09:37 PM #5
    h2o_polo_boi
    h2o_polo_boi is offline
    Registered User
    Join Date
    04-05-2007
    Posts
    3
    Quote Originally Posted by mikerickson
    The Cell Value is equal to your start value.
    Then press the format button, choose FONT from the top, select the color (middle of the right side).
    For testing, it would be best to choose light blue rather than white.
    alright dude...I got it! You're a genius. Thanks!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1