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

[Astha_M]

Hi VIjay,

This can be achieved using macro for conditional formatting.

Regards,

Astha

[Former Member]

Macros is not an option for my client. We want to avoid macros due to security reasons