EPM Conditional formatting

[Former Member]

Hi,

I Want to do the formatting liks this, is it possible..

please suggest

Regards.

Surya

[Former Member]

Hi Surya,

Yes it is possible but please provide more details.From above screenshot we can not assume your requirement so please explain your exact requirement and provide what exactly conditional formatting you want.

[Former Member]

Hi sir,

I need the account_2 need to be format  only at 2014.07 and  2014.08, rest of the account doesn't need formatting at 2014.07 and 2014.08.

Please help me out.

Regards.

Surya

[Former Member]

Hi surya,

Is your report is static or dynamic? In your report you have to apply only on 7 and 8 month or specific 2014.07 and 2014.08 ?

[Former Member]

Sorry sir,

It is Dynamic report,  month would be change as per the selection but it is offset of 2014.04. i.e.

offset(2014.04,3), offset(2014.04,4)

[Former Member]

Sir ,

Any suggestion...

[Former Member]

Hi surya,

Sorry for late reply. If your rows are (Static) fixed then you can try using EPMCopy range function.

Hope this will solve your problem.

[Former Member]

You can use formatting using name ranges.

This video shows how to do it:

http://wiki.scn.sap.com/wiki/download/attachments/281281278/Dynamic_Formatting.mp4?version=1&modific...

Also, there are good stuff here:

EPM Add-in Academy - Enterprise Performance Management - SCN Wiki

Hope this help.