After export activity table from Primavera P6 to Excel, it’s very hard to distinguish WBS level.
I will show you how to color WBS level automatically so we can have report like in P6.
- Step 1:
Follow this article to insert the “WBS Level” column : https://doduykhuong.com/2018/04/01/primavera-p6-export-to-excel-how-to-identify-wbs-level-for-activity/
- Step 2:
Go to Conditional Formatting -> Manage Rules
Create a New rule. Select Use a formula to determine which cells to format
In the formula box enter : =IF($A2=0,TRUE)
Select a color for WBS Level 0.
In the Applies to box, click the arrow icon to select the cells.
We select nearly the whole table.
Now every WBS Level 0 will have green color.
Then we create Rule for other WBS Level: 1, 2, 3
Now the report is very colorful 🙂
i iam doing this but i face problem such after adding conditional formatting formula i dnt c any change
Kindly check your formula carefully. It’s very easy to have a mistake.
Thank you very much, it worked out very well. Keep up the good work.
LikeLiked by 1 person