Remove conditional formatting from parent row

Leann Gibson

Is there a way to remove the conditional format from the parent row? I want the parent row color to stay a specific color, regardless of the dates, etc. See sample, I want the blue to cover the full row.

Lachlan Stead

Fastest way is to add a condition to the conditional formatting rule like below image.

In your case this would state: "If 'Checkbox Column is Checked' and 'Status is not blank' then apply 'this format' to the 'entire row'.

This may not be the best way to do it but it is the fastest workaround that I can see just glancing at it.