I need to format the text in each row in my sheet based on an expiration date entered in column E. If the expiration date is within 2 weeks of the current date (or expired), I need to highlight the entire row red & Bold.



I have it working for the first data row, using the following rule in the 'Format values where this formula is true:

=($E$2 < NOW()+14)

And in the column 'Applies To:

=$A$2:$F$2

And this works to format the first row properly when the date changes. But when I try to alter the formulas to apply to the entire document using the following, it doesn't:

Format values where this formula is true:
=($E$E < NOW()+14)

Applies to:
=$A:$F


Can someone help me with the proper formula so each row will be formatted based on the value in column E for that row? Also, I don't want to apply formatting to the first row, since that has the column headers, so I need to apply to rows 2 to the end.

Thanks