HELP! Conditional Formating cell colors relying on dates from other column

[javiUSAF]

I have column L that may or may not be populated with dates that indicate an assigned study. On column N there may or may not be dates indicating the assignment was completed.
In a nutshell,
Once a date is entered in L, clock begins for N.
more than 6 days past L2 date, empty cell (N2)=YELLOW,
more than 9 days past L2 date, empty cell (N2)=Red
if (N2) date completed by 10th day, (N2)=green,
if (N2) completed BUT > 10days from L2 date then N2=green w/stripes)
If no date on L2 or if L2 date <6days from today then N2 remains blank (i'm especially having trouble with this, when I copy down the formats, the N column cells that should be blank turn green)
Below are my formulas
1. =N3-L3>=10 <--green w/stripes
2. =N3-L3>=0 <--green
3. =AND(L3<TODAY()-9,LEN(N3)=0 <--red
4. =AND(L3<=TODAY()-6,L3>TODAY()-9,LEN(N3)=0 <--yellow
5. =AND(L3<=TODAY()-1,L3>TODAY()-6,LEN(N3)=0 <--green (i don't think this one is doing anything)
PLEASE HELP!!! THANK YOU!

 

[AlphaFrog]

1. =AND(N2="", L2>0, Today()-L2>=10) <--Red (10+ days overdue)
2. =AND(N2="", L2>0, Today()-L2>=6) <--Yellow (6 to 9 days overdue)
3. =AND(N2>0, N2-L2<10) <--Green (Completed in less than 10 days)
4. =AND(N2>0, N2-L2>=10) <--Green w\stripes (Completed in more than 9 days)

The order of the CF formulas matters. The 1st condition has priority.

 

[javiUSAF]

Thank you so much for your help. I really appreciate it very much. At first it didn't quite work but when I changed the order it did exactly what I wanted.
Green w/stripes I took to the top then stop if true
Green came 2nd and stop if true
Red 3rd and stop if true
Yellow 4th and stop if true.

Again, thank you so much for helping me and the many others i'm sure you have bailed out.

 

[AlphaFrog]

You're welcome. I'm glad it worked out for you.