format options: How to make the Parent nodes in Bold font for both rows and columns

[Former Member]

Hello Experts,

                    In the IBP Excel Add in reports formatting options how to make the Parent nodes in Bold font for both rows and columns leaving the child node as it is.

regards,

IBP Newbie

[satish_waghmare3]

Hi Aeroshil,

You can unhide EPMFormattingSheet in Excel Add-in.  The EPMFormattingSheet has number of options available to achieve desired format with your Excel Reports/Templates.  These options are available for both Header as well as for actual data. Options like Font Type, Font Size, Text Color, Bkgrd Color, Decimal Places and so on.

I suggest you to experiment/play with EPMFormattingSheet to see what all you can do and how you can do that.

Hope this will help.

Thank you

Satish Waghmare

[Former Member]

Thanks Satish for your response. Will check in the and system and let you know if it satisfies our need.