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 Vijay

Please let me know if your column axis is a static(as shown below) with only those 3 values of 'Category' dimension or dynamic.. with multiple columns having link with other dimensions(Eg: time) as well?

Thanks

Venkat