Conditional Formatting different due dates
Results 1 to 4 of 4

Thread: Conditional Formatting different due dates
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Aug 2019
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Conditional Formatting different due dates

    I have looked and tried, and no luck.

    I need A3 to do 2 things
    When the arrival date is less than the number of days allowed to turn red.
    so it will turn red when a date is entered and also turn red automatically using today's date.

    A1 has arrival date
    A2 Has drop down list with 1 day, 3 day, 5 day. (I can remove "day", if that helps) (same document sheet called Data)

    A3 to turn red...this is where I'll add the received date
    Arrival Allowed days arrived
    08/01 2 08/05
    08/01 3 Cell filled red
    Both cell are filled red, I didn't see an option.
    Excel 2010 & 2013

    Thanks Excel Wonder workers...I'm about 2 hours into trying ..no luck

  2. #2
    MrExcel MVP
    Junior Admin
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    50,383
    Post Thanks / Like
    Mentioned
    54 Post(s)
    Tagged
    11 Thread(s)

    Default Re: Conditional Formatting different due dates

    Welcome to the Board!

    You say cells A1, A2, and A3, but from your image, those would be columns A, B, and C, not row 1, 2, and 3.

    Let's say that you have Arrival in A2, Allowed Days (just number, no "days" in text) in cell B2, and Arrived in cell C2.
    Then, you could use this Conditional Formatting Formula on cell C2:
    Code:
    =(A2+B2) < MAX(C2,TODAY())
    and choose your red formatting option.

    To apply it to a whole range of cells in column C, select the whole range you want to apply it to, then enter the formula as it pertains to the very first cell in your selection. Excel will automatically adjust the formula for the other cells/rows in your selection.
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

  3. #3
    New Member
    Join Date
    Aug 2019
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional Formatting different due dates

    Thank you

  4. #4
    MrExcel MVP
    Junior Admin
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    50,383
    Post Thanks / Like
    Mentioned
    54 Post(s)
    Tagged
    11 Thread(s)

    Default Re: Conditional Formatting different due dates

    You are welcome.
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •