Regarding Macro

[Former Member]

Dear Friends,

I jave prepared one macro like alert.If suppose my X key figure value is less than 5 % then,cell of Z key figure show Green color or X key figure is greater than 5 % then,cell of Z key figure shows RED COLOR.

So i have prepared macro with the help of FUNCTION CELL_BG ( 27 ) & CELL_BG ( 37 ).But problem is that,in planning book Cell of Z key figure show RED or Green Color as per condition but behind that color system shows 27 or 37 No.

So,How can i hide this no.,so that system will show only RED or GREEN cell without any No.( like 27 or 37).

I would really appreciate you ,if you could give the solution for this querry.

Thanks & Regards

Sujay Joshi

APO-Consultant

91-9977600216

[Former Member · Accepted solution]

Hi sujay,

The problem you are facing is because of wrong selection of flag "Change scope" enteries in the Results row attributes.

To achieve the desired results

Double click on the results row settings and modify the "Change scope" settings to "Attributes" instead of "Values" which, it seems you have wrongly selected.

Hope this will solve ur problem.

Remember to reward points if query closed to your satisfaction.

Best regards

Ankur

[Former Member · Accepted solution]

Hi Ankur,

Thanks for your prompt & correct reply.I did that change & i got corrcet requirement of Client.

Thanks ones again

Regards

Sujay