Stop conditional formatting on parent rows
So we're trying to highlight when tasks are past due, so we set up conditional formatting to highlight rows with due dates = in the past and the status = not complete. The issue is this is also applied to parent rows, which have a "due date" because it auto generates from the tasks under it but since it's not a task, it's not marked as complete.
Is there a way so that the conditional formatting isn't applied to parent rows or is there some other workaround here?
Help Article Resources
Check out the Formula Handbook template!