Conditional Formating on Parents
Options
Comments
-
-
Hah! That's great to know. Thank you!
-
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.