Skip to Content
0
Jul 26, 2016 at 07:50 PM

Coloring Specific portion time horizon of a KF

32 Views

Hi,

I have a KF: KF1 which is only editable in "current and future".

When I bring in this KF and using EPM sheet, set color for calculated KFs, the non-edittable portion of this KF (ie. past time periods) in the Excel does not turn up in the selected color.

Could anyone please me how this can be done?

For Example,

say, if WK 10 is current week, and a color is selected in EPM sheet say grey, then the objective is : for any week before Wk 10 should appear in Excel week grey colored vaues.

Regards,

Sourojit