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.
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.
Hi Leann,
Depending on your conditional formatting structure it might be possible to reorder them to achieve what you want.
To add to Lachlan's excellent suggestion. You could automate it with a helper column with a formula that would show if it's a parent or not.
Would that help/work?
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
I want to push the latest status log sheet entry to the dashboard. I have added working columns for the last date, recent value (0 or 1) and recent status (text field). The recent columns are blank except for the most recent data rows (that part of the sheet is working). I have a project metric sheet template across topics…
Is there an overall calendar setting whereby I can choose a specific column to display in the calendar view? I have created an additional column that gives the task name (located in a child row) as well as the main task (in it's parent row). I want that to display in the calendar. Overall creating a content calendar and…
Hello We converted over in July to the usm. We have alot of discrepancies where people are in usm and not the admin center and vice versa. Is anyone else see the same and feel this is an issue? Also, I would like to brain storm with the group as to how procedurally you will be doing the true up process and terminations as…
