Conditional Formating on Parents

Genevieve P.

Hey @Andrew R.

Personal preference! 🙂

Here, it's easiest to show in a sheet:

Versus

Andrew R.

Hah! That's great to know. Thank you!

Todd M

I think there is a much simpler way to do this that I'm using currently - though based on one of the earlier comments here. You simply need to have the Helper Column Count Ancestors. This will label each row with a number 0 -> Whatever

=COUNT(ANCESTORS([Task Name]1))

Then you can Conditional format based on what level in the hierarchy it is. I found that some of the previous solutions (where you count Children) actually caused problems for me in my use if I didn't have Children under some rows as those wouldn't get a number and then wouldn't format the same as others in the same level of hierarchy.