Subtracting two cell dates and highlight if over due by a certain amount of days

Discussion in 'Excel' started by Desiree Stevenson, Aug 4, 2016.

  1. Desiree Stevenson

    Desiree Stevenson

    Joined:
    Aug 4, 2016
    Messages:
    1
    Likes Received:
    0
    Hello I am not that good at excel and I am trying to highlight cells that have dates greater than a certain number of weeks to be either yellow, green or red

    I'm trying to add two dates together in two different columns and if the outcome is greater than

    21 days =hightlight yellow
    Greater than 28 days = Hightlight Green
    Greater than 14 days = hightlight Red

    now sure how thats done in excel?
     
    Last edited by a moderator: Aug 5, 2016
    Desiree Stevenson, Aug 4, 2016
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. deadciv
    Replies:
    0
    Views:
    479
    deadciv
    Jan 5, 2012
  2. lga3q
    Replies:
    1
    Views:
    631
    lga3q
    May 18, 2012
  3. David92595
    Replies:
    1
    Views:
    712
    lcaretto
    Jul 25, 2012
  4. palombo
    Replies:
    0
    Views:
    345
    palombo
    Jul 2, 2012
  5. Martin Sprenz

    Pivot table Days to Months

    Martin Sprenz, Mar 17, 2015, in forum: Excel
    Replies:
    0
    Views:
    243
    Martin Sprenz
    Mar 17, 2015
  6. Shivesh
    Replies:
    1
    Views:
    266
    XLPadawan
    Jun 14, 2016
  7. Kyle Hinterman

    How to paste the same cell one tab over

    Kyle Hinterman, Nov 20, 2015, in forum: Excel
    Replies:
    1
    Views:
    356
    XLPadawan
    Jun 10, 2016
  8. Lillian Livingston
    Replies:
    0
    Views:
    147
    Lillian Livingston
    Jul 18, 2016
Loading...