+ Reply to Thread
Results 1 to 3 of 3

Conditional Formating

  1. #1
    Registered User
    Join Date
    07-07-2013
    Location
    Kuwait
    MS-Off Ver
    Excel 2010 at work/ 2013 home
    Posts
    2

    Conditional Formating

    I am not sure if this is the right area, but here goes.
    I am deployed with the US Army and need to track customs documents through the process of being completed from the time that I receive them until the time we hand them off to shipped out.

    Customs excel.JPG

    We have 15 days from the time that we receive the document to return to the port.
    Customs usually process the document in 5-7 days
    We usually can deliver the finished customs document the same day, if not the next day.

    What we were hoping to be able to do is in A2 is set up a conditional formatting that goes from yellow, red to green when completed, once a date is input in D2 "Delivered to Port".

    As you can see, I figured out how to put a check mark when a date is input, but is there a way to have the X populate it until the date is input?

    Many of these documents are time sensitive. When we fail to deliver them on time, we are fined or charged a penalty. I am trying to get a handle on the process and be able reduce or eliminate the extra costs.

    Thank you in advance.
    Last edited by SLC.LUVS.PHILLY; 07-09-2013 at 03:04 PM.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: Conditional Formating

    Hi
    adding a sample SHEET makes things easier - Thx

  3. #3
    Registered User
    Join Date
    07-07-2013
    Location
    Kuwait
    MS-Off Ver
    Excel 2010 at work/ 2013 home
    Posts
    2

    Re: Conditional Formating

    Here is a sample of what I started to work with:
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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