How to auto color WBS sequence- Cond formatting
Hi Team,
Can we set some conditionally format to auto color the line:-
For example
WBS
1
1.1
2
2.2
what i want is the we will set two color one for parent wbs and for child wbs
now if i add 3 and 3.3 its should automatically format the complete row.
Please help
Answers
-
If you're wanting all of the parent rows to be the same color and all the child rows to be a different color, that's definitely doable. I achieve this by creating a helper column called Level.
In the Level column, I enter this formula: =count(ancestors())
This counts how many ancestors the current row is beneath. So, for a 1.1.1, it would return the number 2, because there are a parent row and a grandparent row.
Then you can set your conditional formatting to one color if Level is 0 (parent row), and a different color if Level is 1 (child row). You can then hide the Level column so it doesn't clutter your sheet.
Hope this helps!
Best,
Heather