IF function based on dates in cell

Hi - 

Like many posts, relatively new to excel, though I have some working experience. I'm trying to build a page that would highlight an entire row a certain color if a date is too far removed from a =TODAY() cell.

Its basically a way to ensure that tasks do not get too out of hand and I could visually see if something was done 2 weeks ago, and it should have been done within a week, then I would have a visual trigger to show that that task needs attention.

I built my excel sheet so that tasks would need to be checked off in a linear fashion along the same row across multiple columns. So long as a date is input into the next column and the last date input isn't too far removed from the =TODAY() cell, a row would remain white. However, once it's been a certain length of time, then that row would highlight red.

I know this is complicated, but any insight would be appreciated.