Consult123
Banned user
- Joined
- Dec 30, 2023
- Messages
- 22
- Office Version
- 365
- 2010
- Platform
- Windows
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)
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)