I have/am looking at _Excel_VBA_Programming_for_Dummies_ and
_Visual_Basic-6 amongst my Excel references that might fit what you are
looking for. Helps me! (usually...)

if this is all you need, it would be better if your work with the
"conditional format" in the "format" menu.

You can also check out this website, as it has many computer programming books,
as well as many classroom instructional books.
http://www.flazx.com

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.

I couldn't understand what your are trying but you can write the if as a
formula in the column for differences

Continuing with your first example in k3 you can write =if(j3="",0,J3-A1)

Then you try again with the conditional formant