+ Reply to Thread
Results 1 to 3 of 3

Conditional Formatting - Expiry Dates

  1. #1
    Registered User
    Join Date
    06-30-2016
    Location
    Berlin, Germany
    MS-Off Ver
    Excel 2010
    Posts
    1

    Conditional Formatting - Expiry Dates

    Hi all,

    I'm creating a project management file for a team of developers who work in the fashion industry.

    Capture.PNG

    The ETA is entered when the developer enters a date when they expect their labdip to return from a supplier.
    There is currently a conditional format in for the following:
    Capture1.PNG

    My question:
    I also need a conditional format in for the ETA (c.S) and Date Received (c.T) columns so that...
    1. If the labdip is received before the ETA, both fields go green.
    2. If the labdip is received after the ETA, both fields go yellow.

    For context - if the labdip is received in time and the box goes green (like all other boxes), then the whole project is on time. I need the field to go yellow so that when it comes down to the end point and the supplier wants to ask for a 2 weeks delay in shipping the goods, it is visibly clear to the developer that the supplier was late in sending the labdip (or whatever it is!) and has a right to claim a discount etc.

    I know how to add a conditional format in for the following columns so that when something is rejected it goes red and the adjacent comment box also goes red. But I can't seem to figure how to merge these two formulas!
    Capture2.PNG

    Hope this is clear

    Thanks in advance!!

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Conditional Formatting - Expiry Dates

    You should not SEARCH for REJECTED.

    Please Login or Register  to view this content.
    is the formula you need.
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

  3. #3
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Conditional Formatting - Expiry Dates

    Attach a sample workbook if you need more help.
    Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

+ 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. Replies: 4
    Last Post: 10-03-2014, 09:03 PM
  2. Use conditional formatting to track expiry dates in multiple fields
    By shamilton in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-15-2013, 12:55 AM
  3. Conditional Formatting for expiry dates
    By otenemel in forum Excel General
    Replies: 15
    Last Post: 08-01-2013, 10:11 PM
  4. Conditional formatting for expiry dates (excel 2007)
    By lisa_lula in forum Excel General
    Replies: 1
    Last Post: 09-04-2012, 09:59 PM
  5. Conditional Formatting using different expiry dates
    By ConfusedCoxy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-30-2012, 01:38 PM
  6. Conditional Format Expiry Dates
    By Paul Cooke in forum Excel General
    Replies: 2
    Last Post: 03-01-2010, 07:26 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