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:
    485
    deadciv
    Jan 5, 2012
  2. lga3q
    Replies:
    1
    Views:
    636
    lga3q
    May 18, 2012
  3. David92595
    Replies:
    1
    Views:
    715
    lcaretto
    Jul 25, 2012
  4. palombo
    Replies:
    0
    Views:
    351
    palombo
    Jul 2, 2012
  5. Martin Sprenz

    Pivot table Days to Months

    Martin Sprenz, Mar 17, 2015, in forum: Excel
    Replies:
    0
    Views:
    247
    Martin Sprenz
    Mar 17, 2015
  6. Shivesh
    Replies:
    1
    Views:
    272
    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:
    370
    XLPadawan
    Jun 10, 2016
  8. Lillian Livingston
    Replies:
    0
    Views:
    161
    Lillian Livingston
    Jul 18, 2016
Loading...