Results 1 to 5 of 5

Conditional Formatting: Selection from a drop down list and a date field change row color

Threaded View

betheeem Conditional Formatting:... 05-08-2015, 10:49 AM
FDibbins Re: Conditional Formatting:... 05-08-2015, 11:14 AM
FDibbins Re: Conditional Formatting:... 05-08-2015, 11:14 AM
betheeem Re: Conditional Formatting:... 05-08-2015, 11:19 AM
betheeem Re: Conditional Formatting:... 05-15-2015, 11:29 AM
  1. #1
    Registered User
    Join Date
    05-05-2015
    Location
    Pittsburgh, PA
    MS-Off Ver
    2007/2010/2011/2013
    Posts
    18

    Conditional Formatting: Selection from a drop down list and a date field change row color

    I have the attached spreadsheet that is tracking a project. I have used conditional formatting to do the following.

    1) If status the task is marked Complete ($D2) the row text will strikeout and turn light gray
    2) If projected due date ($C2) is coming in the next two weeks it change the row to yellow
    3) If projected due date ($C2) is over due it will change the row to red

    I would like to add the following but cannot get it to work.

    1) I would like to change the row to orange if the projected start date ($B2) is today or past due and the task status still is marked Pending ($D2) *Status is a drop down list option.
    a) this will proceed the yellow coding above
    b) the row would stay red if the task status is In Progress and past due
    2) Would like the row to change to another color if the task status is marked Complete ($D2) and the Actual completion Date ($E2) is blank

    No matter what I try it will not work.

    Any assistance would be helpful.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 03-31-2015, 02:50 AM
  2. Replies: 13
    Last Post: 07-09-2014, 04:10 PM
  3. [SOLVED] Change color of cell based on drop down selection
    By madhatter40 in forum Excel General
    Replies: 3
    Last Post: 12-14-2012, 07:27 PM
  4. Row color change based on drop down selection
    By bigbluesfan22 in forum Excel General
    Replies: 7
    Last Post: 08-01-2012, 09:15 AM
  5. Replies: 6
    Last Post: 03-20-2012, 12:08 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