Dimension wise formatting BPC

[Former Member]

Dear All,

I have a client requirement that is I need to color the column in excel file as per the dimension i.e. different dimension,different color.

Please see the attachment below.

The above image comes as per the standard formatting.

Now the client requirement is as per the below.

Please help me out.

[former_member186338 · Accepted solution]

You can use conditional formatting for row axis headers with formula like: Column()=1...

Vadim

[former_member186338 · Accepted solution]

Sample:

Result:

Vadim

[Former Member · Accepted solution]

Hi Vadim,

Thanks for the fast reply...you are a genius.