# 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. ## 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. ## 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

3. ## Re: Excel 2007 Conditional Format ROW between TODAY() and +14 Days

Try this formula

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

4. ## Re: Excel 2007 Conditional Format ROW between TODAY() and +14 Days

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

#### Posting Permissions

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