+ Reply to Thread
Results 1 to 9 of 9

Hide Cell Formula until Entry is made.

  1. #1
    Registered User
    Join Date
    10-14-2015
    Location
    Llandrindod Wells, Powys
    MS-Off Ver
    2013
    Posts
    6

    Hide Cell Formula until Entry is made.

    Hello Forum Group
    I have a Gannt table that I am using for a project. It has a formula: =WORKDAY(D11,C11,nonworking) that shows the finish date of a project. However when I expand the rows for potential new entries the date comes up as: 00/01/1990. What I want to do is hide that until a date is put in the start date column
    Capture.PNG.

    I have attached a picture of my spreadsheet in anticipation. Thank you very much.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

    Re: Hide Cell Formula until Entry is made.

    =if(D12="","",WORKDAY(D12,C12,nonworking) will do that for you.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Registered User
    Join Date
    10-14-2015
    Location
    Llandrindod Wells, Powys
    MS-Off Ver
    2013
    Posts
    6

    Re: Hide Cell Formula until Entry is made.

    Hi there Glen
    Thank you very much for your reply. Should there be another bracket on the end of your formula as I only see three :-) I did input that formula and it did clear the cell, however when i then inputted a date into the start date column the finsih date remained blank. I have attached the actual file to see if you may be able to help.
    Attached Files Attached Files

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

    Re: Hide Cell Formula until Entry is made.

    Sorry about that!! Yes, it needs the last ). However, don't forget that your formula will calcuate an end date only when you have BOTH the start date and a duration.

  5. #5
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

    Re: Hide Cell Formula until Entry is made.

    You'll also have to add a term to your CF like this, too:

    =AND(G$6>=$D7,G$6<$E7,$E7<>"")

  6. #6
    Registered User
    Join Date
    10-14-2015
    Location
    Llandrindod Wells, Powys
    MS-Off Ver
    2013
    Posts
    6

    Re: Hide Cell Formula until Entry is made.

    Thank you very much Glen that is so helpful, your last message what did you mean by adding the formula to CF ??

    Kind Regards

    Richard

    ps I am about to embark on an excel course :-)

  7. #7
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

    Re: Hide Cell Formula until Entry is made.

    Open V1. You'll see that the unstarted tasks are all shaded. That's clearly incorrect. Open V2. I amended the Conditional Formatting as suggested to shade only those tasks that have start/end dates
    Attached Files Attached Files

  8. #8
    Registered User
    Join Date
    10-14-2015
    Location
    Llandrindod Wells, Powys
    MS-Off Ver
    2013
    Posts
    6

    Re: Hide Cell Formula until Entry is made.

    Thank you Glen very much :-)

  9. #9
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

    Re: Hide Cell Formula until Entry is made.

    You're welcome and thanks for the Reputation.

+ 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] Trying to copy formula from cell above if an entry is made in the row
    By LeanAccountant in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-08-2014, 06:04 AM
  2. Replies: 4
    Last Post: 06-15-2011, 05:33 PM
  3. Autosubtracting a value from same cell a manual entry is made
    By tony324 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-04-2011, 02:10 PM
  4. Make text visible when entry made in another cell
    By lilraskle in forum Excel General
    Replies: 1
    Last Post: 01-27-2011, 01:19 PM
  5. How make macro run if entry made in a particular cell
    By Launchnet in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-19-2010, 08:00 PM
  6. Change text colour when entry made in another cell
    By thalt in forum Excel General
    Replies: 5
    Last Post: 01-10-2010, 07:13 AM
  7. Replies: 5
    Last Post: 11-10-2006, 06:38 AM
  8. [SOLVED] one cell entry made up of two lookup results
    By Orion in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-22-2005, 08:06 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