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?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. deadciv
    Replies:
    0
    Views:
    497
    deadciv
    Jan 5, 2012
  2. lga3q
    Replies:
    1
    Views:
    649
    lga3q
    May 18, 2012
  3. David92595
    Replies:
    1
    Views:
    724
    lcaretto
    Jul 25, 2012
  4. palombo
    Replies:
    0
    Views:
    365
    palombo
    Jul 2, 2012
  5. Martin Sprenz

    Pivot table Days to Months

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