Results 1 to 3 of 3

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

Threaded View

  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

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