IBP Format sheet-Approach to do Color Code formatting for Cells without Zero values in Planning View

[Parthi4]

Hi Experts, All,

In IBP Formatting sheet -

Need Approach to do Color Code formatting for Cells without Zero values in IBP Excel Add-in Planning View Template.

As per user requirement, we have made 'Conditional Formatting' (If Key Figure Cell Value is NOT Equal to '0' (Zero) then display in Red color for the IBP Key Figure.

This color code Formatting is done in 'IBPFormattingSheet' for the Key Figure in 'IBP DEVELOPMENT System' and tested and working fine.

The Question is :

Do we need to do this cell Color Code Formatting directly in Planning View Templates in IBP PRODUCTION system ?

Or is there any way/option to Transport or Export from Development system to Quality system and to Production system ?

Appreciate your help in this regards.

Thanks.

Parthi

[peter_casper]

Hi @Parthi4,

you can't transport planning book templates but you can open the mentioned view in IBP Test system, log-off and log-on in IBP Prod again. Afterwards you can add or update the respective planning view in IBP Prod. Pretty easy.

Alternative: Apply the same changes to the formatting sheet in IBP Prod.

BR, Peter