+ Reply to Thread
Results 1 to 3 of 3

Drop-down populated based on whether cell is blank or not

  1. #1
    Registered User
    Join Date
    05-31-2011
    Location
    Alpharetta, GA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Drop-down populated based on whether cell is blank or not

    I have a workbook that tracks project status. Basically what I have is two columns that either have dates or not - acutal start and actual complete. I then have a column that has a drop down list with statuses - In Progress, Not Started, Completed, and others. What I want is that by default the status column should be 'Not Started', but then when an Actual Start date is populated, when Actual Complete date is populated, status status changes to In Progress, BUT also will allow the user to select other possibilities from the list if applicable.

    I'm new to the board, so I hope that is enough info. I cannot post the sheet due to proprietary info.
    Attached Files Attached Files
    Last edited by ss7745; 07-25-2013 at 04:12 PM. Reason: EDITED TO INCLUDE Sample Workbook

  2. #2
    Forum Expert GeneralDisarray's Avatar
    Join Date
    09-15-2011
    Location
    Pittsburgh, PA, USA
    MS-Off Ver
    Windows Excel 2016
    Posts
    1,416

    Re: Drop-down populated based on whether cell is blank or not

    Please post s similar version of the sheet, cleaned of proprietary information.
    Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.

    Please,mark your thread [SOLVED] if you received your answer.

  3. #3
    Registered User
    Join Date
    05-31-2011
    Location
    Alpharetta, GA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Drop-down populated based on whether cell is blank or not

    I edited my initial thread above with a basic workbook of what I am looking for. Please help.

+ 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] colour row based on column criteria ,populated by numbers or blank
    By cfinch100 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-30-2013, 04:14 PM
  2. Blank unless another cell is populated than a formula is applied
    By greenham in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-14-2012, 02:22 PM
  3. Range populated based on drop down choices
    By Bcoggin in forum Excel General
    Replies: 1
    Last Post: 02-02-2011, 12:31 PM
  4. [SOLVED] Insert blank row above populated cell
    By Bevy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-06-2006, 10:10 AM
  5. Can a cell have a drop down list and can also be auto populated
    By Adrian in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-17-2005, 02:06 AM

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