I tried using conditional format. I inserted a column designated as
difference and ran a formula to determine the number of days.
Problem is that if no date  is entered  you get an answer of 3287. So
by using conditional format all of the cells will automatically
highlight red  even if a date hasn't been entered yet. This is not
exactly what I need as it eliminates the point of highlighting
delinquencies over 7 days.

I was tryign to think of a if then statement  to cover the issue.
example:

Sub
If J2 is empty
Then True
If True
Then run  compare

With
If A1-J2>=7
Then statement=(true)
If true
Then run flag

I know my coding is incorrect. Just trying to explain what I'm
trying to accomplish.