How to use conditional formula to change color when a field is less than other and contains Name

[SooKim]

[FONT=&quot]Hello,[/FONT]
[FONT=&quot]I need help using the conditional formatting colors on Close Date.[/FONT]
[FONT=&quot]When Close Date is less than (270 days, 180 days , 120 days, or 60 days) from As of Date from the NAME (e.g., Introduction, Meeting Scheduled, Meeting Confirmed, and Sales closed) I want the close date cell to change color.[/FONT]
[FONT=&quot]Introduction Stage is Close Date (< =270 days) from As of Date change color Yellow[/FONT]
[FONT=&quot]Meeting Scheduled Stage is Close Date (< =180 days) from As of Date change color Yellow[/FONT]
[FONT=&quot]Meeting Confirmed Stage is Close Date (<= 120days) from As of Date change color Yellow[/FONT]
[FONT=&quot]Sale closed Stage is Close Date (< =60days) from As of Date change color Yellow[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]The formula I have doesn't work correctly, will you tell me what I did wrong and provide me a better formula?[/FONT]
[FONT=&quot]=COUNTIFS($b2,"Introduction",$c2,">="&$A2,$c2,"<="&EDATE($A2,270))+ COUNTIFS($B2,"Meeting Scheduled ",$c2,">="&$A2,$c2,"<="&EDATE($A2,180))+ COUNTIFS($E2,"Meeting Confirmed",$c2,">="&$A2,$c2,"<="&EDATE($A2,120))+ COUNTIFS($E2,"Sale Closed",$c2,">="&$A2,$c2,"<="&EDATE($A2,60))https://docs.google.com/spreadsheets/d/1K5YRI3olKNtuTF8rZgBkrvqAiScCwr9ges2oKsfOPPE/edit#gid=0[/FONT]

 

[Fluff]

Hi & welcome to MrExcel.
You're link has not been marked for sharing & is therefore asking me to sign-in.
Can you please mark the file for sharing & provide a new link.