Percent Complete Versus Start and End Date Formulas For Conditional Formatting

[Consult123]

Hello all,

I'm having trouble with conditional formatting formulas for the following percent complete versus start and end date situations. I've also included a screenshot to give you a better picture.
-On Track (Trigger- Based on the current date, the task will be completed on time by the due date)
-Complete (Trigger- Column F at 100%)
-At Risk (Trigger- Based on the current date (halfway through duration)and percent complete, the task will not be completed on time by the due date)
-Off Track (Trigger- Based on the current date (latter half of duration) and percent complete, the task will not be completed on time by the due date)
-In Progress (Trigger- Column L >1% for the first seven days from the start date)
-Not Started (Trigger- Column F at 0%)
-Cancelled (Trigger- Columns D and E not populated with date and Column L blank)

 

[Consult123]

How do we cancel this thread so I can start a new one? @Fluff

 

[Fluff]

You don't cancel this thread, just be patient & someone will help.

 

[Consult123]

You don't cancel this thread, just be patient & someone will help.

This thread is extremely confusing. Please lock this post or delete it.

 

[Consult123]

You don't cancel this thread, just be patient & someone will help.

I redid all the columns and thus made it confusing. Please allow me to make a new thread that is less confusing!