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

  • Heather Duff
    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