Results 1 to 4 of 4

Excel 2007 Conditional Format ROW between TODAY() and +14 Days

This is a discussion on Excel 2007 Conditional Format ROW between TODAY() and +14 Days within the Excel Questions forums, part of the Question Forums category; I can only seem to find info on this where there is a specific date range or they only want ...

  1. #1
    Board Regular
    Join Date
    Mar 2005
    Posts
    148

    Default Excel 2007 Conditional Format ROW between TODAY() and +14 Days

    I can only seem to find info on this where there is a specific date range or they only want to highlight an individual cell.

    I currently have this as my formula which highlights the entire row if the date in cell "T" is exactly 14 days from today's date, but not between, i.e. today it would highlight only dates that have 6/30/2011. I need it to highlight the entire row if the date falls between TODAY() and 14 days from today.

    =INDIRECT("T"&ROW())=DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY())+14)

    I know it's close, just need to know where/what to add to it.

    Thanks!

    Toni

  2. #2
    MrExcel MVP Jerry Sullivan's Avatar
    Join Date
    Mar 2010
    Location
    San Diego, California
    Posts
    6,784

    Default Re: Excel 2007 Conditional Format ROW between TODAY() and +14 Days

    Hi Toni,

    You can use this formula for all cells on Row2:
    =AND($T2>=TODAY(),$T2<=TODAY()+14)

    To use Conditional Formatting with this formula, let's assume
    you want to apply the formatting to Cells A2:Z100

    Select Cell A2, then open the Conditional Rules Manager
    (In the ribbon: Home > Conditional Formatting > Manage Rules...)

    click New Rule
    Select a Rule Type: pick Use a formula to determine which cells to format
    Rule Description:
    Format values where this formula is true: enter =AND($T2>=TODAY(),$T2<=TODAY()+14)
    Format: Pick your format
    click Ok

    In the Applies To: field, enter =$A$2:$Z100
    (or use the pick range button to select the columns you want)

    That should do it. A key to making one formula work for all the cells is to use
    $T2 in the formula and not $T$2
    Using Excel 2010, 2013

  3. #3
    Board Regular
    Join Date
    Apr 2011
    Location
    Hyderabad
    Posts
    377

    Default Re: Excel 2007 Conditional Format ROW between TODAY() and +14 Days

    Try this formula

    =and(h3>=today(),h3<=today()+14)

  4. #4
    Board Regular
    Join Date
    Mar 2005
    Posts
    148

    Default Re: Excel 2007 Conditional Format ROW between TODAY() and +14 Days

    Rock stars, the both of you!! Thanks, got it to work!

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com