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

[thart21]

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

 

[Jerry Sullivan]

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

 

[anandvarma]

Try this formula

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

 

[thart21]

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