Format lost after export to excel !

[phamtinkt88]

Hi all,

I'm stucking with issue as the image below.

Capture.JPG (142.56 KiB) Viewed 3153 times

Is there anyway to keep that format ?

Thanks all,
Tin Pham

[Martin Ryan]

Is this a slice or an active form? A slice will usually automatically do this for you. And with an active form you can control the formatting using the hidden rows at the top of the sheet.

Alternatively you could put an ellev in a hidden column to determine whether the element is consolidated or not, and then apply conditional formatting based on that ellev result.

Martin

[phamtinkt88]

Is this a slice or an active form? A slice will usually automatically do this for you. And with an active form you can control the formatting using the hidden rows at the top of the sheet.

Alternatively you could put an ellev in a hidden column to determine whether the element is consolidated or not, and then apply conditional formatting based on that ellev result.

Martin

Thanks Ryan, i did it as you said !

[stephen waters]

Is this a slice or an active form? ....
Martin

Thanks Ryan, i did it as you said !

Tin, he is too polite to say so but his first name is Martin!