Hello,
Working on showing the current status of a task with 12 milestones. Each milestone has a period of 10 working days from start to finish and the next milestone cannot start until the previous has been delivered. Within my spreadsheet each milestone is tracked by its delivery date. Would like to show in the first column a stoplight using Conditional Formatting indicating whether or not the task is on time as far as the current milestone.
If Milestone 1 started on 1/1/2018 and today's date was 1/5/2018 it would be green, but if today's date was > 10 (e.g., 1/20/2018), it would be red.
If Milestones 1, 2, 3, & 4 have delivery dates; it should check Milestone 4 to determine the current stoplight and ignore Milestones 1-3.
Sincerely,
Anthony
Working on showing the current status of a task with 12 milestones. Each milestone has a period of 10 working days from start to finish and the next milestone cannot start until the previous has been delivered. Within my spreadsheet each milestone is tracked by its delivery date. Would like to show in the first column a stoplight using Conditional Formatting indicating whether or not the task is on time as far as the current milestone.
If Milestone 1 started on 1/1/2018 and today's date was 1/5/2018 it would be green, but if today's date was > 10 (e.g., 1/20/2018), it would be red.
If Milestones 1, 2, 3, & 4 have delivery dates; it should check Milestone 4 to determine the current stoplight and ignore Milestones 1-3.
Sincerely,
Anthony