Colour specific name name in matrix

[Morten_K]

Hi all,

I have a matrix with a lot of markets and then I have the company name as well, that sums up everything.

Is it possible to use conditional formatting do always colour the company name with a specific colour, so that it is easy for the markets to see, whether they are above or below the average (e.g. gross margin).

Thank you.

[fhill]

Can you mock up and show us something in excel with sample data and the colors you are trying to produce?  I'm having a hard time full grasping the visual you are trying to describe.  Thank You

[Morten_K]

Hi,

I have tried to make an example. In this case it high-lights the Company and then shows all the individuel markets 'normally'.

So what I am searching for is a way to high-light the 'Company' at all times, so that it is easy for the markets for see if the raise the average or not.

[v-chuncz-msft]

@Morten_K,

As an alternative, add a calculated column and apply conditional formatting. Here is a similar case for your reference.

[Morten_K]

Hi - thank you for your reply.

However - I really don't know what to do. Can you be a bit more specific?