How to change color in IBP template
Step 1: Log on to SPA IBP
Step 2: Open the template which you want to change key figure color.
Step 3: In the template select “Edit View” and click on “View Formats” to enable EMP Formatting Sheet.
Step 4: Click on EMP Formatting Sheet
Step 5: Go to Dimension Member/Property Formatting à Row and Click on Add member/Property.
Step 6: In the Member Selection select Key Figures as “Statistical Forecast Qty (0) and click on “Add to multiple selection”. After that go to Multiple Selection Overview and check the member added or not.
Step 7: Select Property Selection and choose the time dimensions (Day, Week, Month, Quarter, Year). Add the below conditions…
High Value/Dimension: 5 (From current week to next 5 weeks’ selection highlighted)
Select Add to Multiple Selection and go to Multiple Selection Overview and check the Selection.
Save the selection and review the Add member/ property and change the color code.
Go to Planning View and Refresh. After 5 weeks key figure data highlighted with color.
If user wants to add multiple conditions follows as..
Value below 180 = Normal color
Value more than 180 = Yellow color
Go to Excel Home -> Conditional Formatting -> Highlight Cell Rules -> Greater than..and condition/Color.
Go to Planning view and Refresh…condition color applied.