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

Ask a Question

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.