+ Reply to Thread
Results 1 to 3 of 3

How to make it so that a cell appears blank according to a value?

  1. #1
    Registered User
    Join Date
    05-12-2016
    Location
    Cyprus
    MS-Off Ver
    2016
    Posts
    4

    How to make it so that a cell appears blank according to a value?

    I have a cell where i have a formula that converts time into minutes. I want it so if the value is 0 in the cell, then nothing appears in the cell. I thought of making the result appear in another far away column and make it disappear with ;;; then making an if statement based on that. But that's not really a good solution so i turn to you oh wise excellians!

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: How to make it so that a cell appears blank according to a value?

    Hi,

    Use conditional formatting to set the font colour to the same colour as the cell background if the cell is zero.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    05-12-2016
    Location
    Cyprus
    MS-Off Ver
    2016
    Posts
    4

    Re: How to make it so that a cell appears blank according to a value?

    Thank you so much

+ 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. [SOLVED] How to make cells blank when referring to another blank cell
    By Tinwelende in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 05-05-2014, 06:09 AM
  2. Replies: 3
    Last Post: 01-23-2014, 12:19 PM
  3. cell appears blank but is not
    By synergio in forum Excel General
    Replies: 1
    Last Post: 12-28-2012, 12:44 PM
  4. Make a shape appears when a cell is selected.
    By romancebao in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-23-2009, 03:40 PM
  5. How do I make a blank cell with a date format blank?
    By Re: Pivot Table/Query in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  6. [SOLVED] How do I make a blank cell with a date format blank?
    By Re: Pivot Table/Query in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  7. [SOLVED] How do I make a blank cell with a date format blank?
    By Re: Pivot Table/Query in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11: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