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 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.

Need Help

4 Replies

  • 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.