How to auto color WBS sequence- Cond formatting

Finops C'ship

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

Heather Duff

Hi @Finops C'ship

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