BEx-in Excel sheet particular row has to highlightned

[Former Member]

Hi folks,

We are having requirement in Bex.

that particular material M00021 has to be highlightened.

Every time we will pull data from R/3.

the colour may be any colour but it has to highlightened irrespective of the kay figures(so exceptions will not work out here).

it is very urgent.

Thanx in advance

Regards,

Vasu.

[Former Member]

Hello vasu,

check if this helps you in any case:

http://www.sap-img.com/abap/download-to-excel-with-format-border-color-cell-etc.htm

thanks,

[Former Member]

Hello Vasu,

You can do it through VB code in the work-book. Is that what you want or the requirement is to highlight it at query level itself?

Regards,

Praveen

[Former Member]

Thanx praveen.

We need to highlight at query level itself.

K if it in work book means where should we do the coding of VB.

[Former Member]

Hello Vasu,

Go through this link

http://help.sap.com/saphelp_erp2004/helpdata/en/f1/0a55f9e09411d2acb90000e829fbfe/frameset.htm

Regards,

Praveen

[Former Member]

Then is it possible to give colour for a particualr row in Bex excel sheet or not?

if it is possible HOW?

[majeed_mohammedabdul]

It is possible to give .But in the workbooks.

U also dont need any VB .

what u can do is save it as a workbook then in the menu

there is conditional formatting . u can use this feature and say the worbook that when u see that particular number highlight the whole row , u can give any colour u like .

Regards

Majeed