Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Unanswered: conditional Formating for dates greater than a certain number of weeks

    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?

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Use the relevant date time function for excel
    https://support.office.com/en-gb/art...8-074152f97b81
    On the face of it the days function looks a contender

    Then apply as many rules as required
    https://www.google.co.uk/url?sa=t&so...TCPx4mq36HLKVA

    Change any cell references from being absolute to relative.

    As an indidual I tend to do this sort of stuff in vba as there is less risk ofscrewing something up,. Iterate through a column that will always hold data
    Test the value
    Apply the (is it color) proprty then move to next col....
    Run it as a macro. By forcong it as code it doesnt matter if users insert or delete rows / columns the macro tests the values it finds and acts accordingly
    Last edited by healdem; 07-31-16 at 00:53.
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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