Conditional formatting for parents.

Mariluz Rijo

I have a schedule sheet but not sure about how to use the conditional formatting of IF to reflect the status in the parents of my child task.

My specific case is the one shown below:

Even though I have conditional coloring format for task to become green as soon as I manually mark each as completed, my parent tasks are not getting automatically marked as completed in the status column nor through the colored formatting.

If there any IF formatting, I can use to have task the parent become "Completed" as soon as my child are manually marked as completed?

Thanks.

Leroy Noriega

Create a '% Complete' Column and convert it to Percent Format.

Right click any column > Edit Project Settings > Start date as Start Date, End Date as End Date and % Complete as % complete > Ok

In the Status column add an IF formula:

=IF([% Complete]@row = 1, "Complete", IF([% Complete]@row = 0, "Not Started", IF(AND([% Complete]@row > 0.001, [% Complete]@row < 0.999), "In Progress")))