conditional formatting with IF/AND function

I'm working on a project and need to add conditional formatting for a range of cells. My goal was to have a formula that would first, determine if the cell had text and second, if text is present then determine if the date in a particular cell plus 7 is less than or equal to the current date. Lastly, I need the full row of that cell to be highlighted. I put together a few formulas but keep getting errors from excel and at this point I'm starting to wonder if it's not possible.

The last formula I worked up was:

=IF(istext(A1),if(and(d1:7<TODAY)),""

I realize there are a ton of inaccuracies within the formula though it was a very rough work in progress.


Can someone please help me with this or tell me if it is even possible?

try using this formula

=AND(ISTEXT($A1),$K2+7<TODAY())

No problem, fell free to post anytime you are stuck, there are lots of people who enjoy helping out.