+ Reply to Thread
Results 1 to 3 of 3

Color Code Actual Date versus Due Date ( Red, Yellow, Green )

  1. #1
    Registered User
    Join Date
    04-17-2009
    Location
    Columbus, Ohio
    MS-Off Ver
    Excel 2003
    Posts
    2

    Color Code Actual Date versus Due Date ( Red, Yellow, Green )

    Okay, New here first off, and I have spent about 2 hours trying to figure this out with no luck.

    Here is what I am looking for:

    I have two Columns:

    One Column is the DUE DATE: Say 2-1-13

    The other Column is the ACTUAL DATE:

    I want the actual date column to do the following:

    1. When No date is entered, I want it YELLOW
    2. When Date is entered before or on the DUE DATE, I want it Green
    3. When no date is entered on or after the DUE Date I want it RED
    4. When Date is entered After DUE DATE, I want it RED as well.

    I would apprecitae any and all help.

    Thanks,
    Brian

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,620
    Brian

    Which column is DUE DATE?
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    04-17-2009
    Location
    Columbus, Ohio
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Color Code Actual Date versus Due Date ( Red, Yellow, Green )

    In this example, I am Using Column Q for Due Date, and R for Actual.

    Data Starts on Row 7.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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