Forum Discussion

Morten_K's avatar
Morten_K
Regular Visitor
9 years ago

Colour specific name name in matrix

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...
Need Help
fhill's avatar
fhill
Icon for Resident Rockstar rankResident Rockstar
9 years ago

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's avatar
Morten_K
Regular Visitor
9 years ago

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's avatar
    v-chuncz-msft
    Icon for Community Support rankCommunity Support
    9 years ago

    Morten_K,

     

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

    • Morten_K's avatar
      Morten_K
      Regular Visitor
      9 years ago

      Hi - thank you for your reply.

       

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