Macro's - Background color

[Former Member]

Hi All,

I have the following problem:-

The requirement is that if a keyfigure X is populated for a period,a keyfigure Y should be made orange for the same period.

I have used the Cell_bg function to do this.

It works fine in some cases.

When i put a value in X, the color of Y becomes orange.

But when i remove the value in X and hit enter(since this is a default macro), Y doesnt become blank.

It then becomes blank when i Save.

Please help.

Regards,

Anuradha

[Former Member · Accepted solution]

have you imported the macro from the standard SAP macros. If not please import from 9AEXAMPLES View(Macro examples)

[Former Member · Accepted solution]

Yes indeed CELL_BG is a Standard SAP MAcro

[Former Member · Accepted solution]

Hi,

How is the else condition defined (ie, when no value in kfigure)?

try Cell_BG( 2 )