Conditional Formatting using EPMFormat sheet

[#1]

hi Team,

Is there a way to have conditional formatting works using EPMFormatting sheet? For Eg. I have below EPM report requirement where I have show Actual, Plan and variance in the report and I have to apply color code on Plan based on variance.

If the variance is negative then Plan should be highlighted with Red color

if the variance is positive then Plan should be hightlighted with Green color

if the variance is close to zero then highlight with Amber.

I have tried using conditional formatting in the EPMFormat sheet but it does not reflect the colors as desired. Please note that if I apply conditional formatting on Variance column based on variance values it works but if I apply conditional formatting on Plan column based on on Variance values conditional formatting does not work.. I have been playing around with EPM formatting sheet alot from last few days but in vain. Any help is highly appreciated.

Thanks

Vj

[Former Member]

Hi,

Check below video from EPM Academy on similar requirement.

http://wiki.scn.sap.com/wiki/pages/viewpage.action?spaceKey=CPM&original_fqdn=wiki.sdn.sap.com&title...

Formatting ->Conditional Formatting.

Hope it helps..

regards,

Raju

[Former Member]

I have seen this video before and it will not work for my scenario.

[Former Member]

Hi,

Can you change your formatting from PLAN to Variance column. I think that is easy using standard  and conditional formatting (Format all cells based on their values)

Hope it helps..

regards,

Raju

[Former Member]

but unfortunately, my requirement is to format PLAN column only and not the variance column.  Just hoping there should be a way to do this formatting sheet.