+ Reply to Thread
Results 1 to 8 of 8

Excel 2007 : Need cells to highlight within 30 days

  1. #1
    Registered User
    Join Date
    07-21-2012
    Location
    england
    MS-Off Ver
    2010
    Posts
    5

    Need cells to highlight within 30 days

    I am very new to conditional formatting (as in first time ever) and need to get help.
    I have attached a document with random dates on it and need to have the cells show green if its within 30 days of the date the following year.
    Then turn yellow from 30 days to the date the following year.
    Then red if its past the date.
    This document will also be updated with new dates so it would be ideal if lets say i change one of the dates to 2012 for the year then its will automaticly change back to green.
    If that is not possible then i just need to know how to modify the code to do it. Thank you for any assistance.
    Attached Files Attached Files

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Need cells to highlight within 30 days

    Hi lionofjudah,

    Welcome to the forum.

    Need more clarity on criteria :-

    need to have the cells show green if its within 30 days of the date the following year.
    Then turn yellow from 30 days to the date the following year.
    Then red if its past the date.
    What is the other date to which you are comparing given dates? Is it next year i.e., 1/1/2012 ?
    within 30 days of 1/1/2012 = Green
    then what is the critiera for yellow and red?

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

  3. #3
    Registered User
    Join Date
    07-21-2012
    Location
    england
    MS-Off Ver
    2010
    Posts
    5

    Re: Need cells to highlight within 30 days

    lets say cell A1 has the date of 7/21/11 the cell would be green untill 6/20/12 then it would go yellow on 6/21/12 untill 7/22/12 when it would turn red

  4. #4
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Need cells to highlight within 30 days

    Hi lionofjudah,

    See the attached workbook where I have applied the required conditional formatting basis your above post:-
    highlight cell - lionofjudah.xlsx

    Regards,
    DILIPandey

    <click on below 'star' if this helps>

  5. #5
    Registered User
    Join Date
    07-21-2012
    Location
    england
    MS-Off Ver
    2010
    Posts
    5

    Re: Need cells to highlight within 30 days

    Thank you very much it looks like this will work prefectly.

  6. #6
    Registered User
    Join Date
    07-21-2012
    Location
    england
    MS-Off Ver
    2010
    Posts
    5

    Re: Excel 2007 : Need cells to highlight within 30 days

    Thanks again for the formating. I have applied it to my excel I have now run into another issue in making this as customer friendly as possible. I need to have the account section change to yellow or red if anything in that row is yellow or red. Then I also need to have the persons name be highlighted yellow or red in accordance with their training date. Thank you for any farther assistance.
    Attached Files Attached Files

  7. #7
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Excel 2007 : Need cells to highlight within 30 days

    Hi lionofjudah,

    By account section, do you mean column A?
    You need to have person names to be highlighted but Persons name are already having conditional formatting applied

    Considering above, would suggest you to create few examples covering all you scenarios and upload the file back. thanks.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>

  8. #8
    Registered User
    Join Date
    07-21-2012
    Location
    england
    MS-Off Ver
    2010
    Posts
    5

    Re: Excel 2007 : Need cells to highlight within 30 days

    I have made corrections to the example and wrote notes next to each one. I hope this helps.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1