Primavera P6 export to Excel. How to color WBS level automatically

After export activity table from Primavera P6 to Excel, it’s very hard to distinguish WBS level.

Primavera P6 export to Excel. How to identify WBS level for activity-1

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/

Primavera P6 export to Excel. How to identify WBS level for activity-3

  • Step 2:

Go to Conditional Formatting -> Manage Rules

Primavera P6 export to Excel. How to color WBS level automatically-1

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.

Primavera P6 export to Excel. How to color WBS level automatically-2

Click OK.

In the Applies to box, click the arrow icon to select the cells.

Primavera P6 export to Excel. How to color WBS level automatically-3

We select nearly the whole table.

Primavera P6 export to Excel. How to color WBS level automatically-4

Click OK.

Now every WBS Level 0 will have green color.

Primavera P6 export to Excel. How to color WBS level automatically-5 (1)

Then we create Rule for other WBS Level: 1, 2, 3

Primavera P6 export to Excel. How to color WBS level automatically-6

Now the report is very colorful 🙂

Primavera P6 export to Excel. How to color WBS level automatically-7

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s