Forum Discussion

kennoe's avatar
kennoe
Helper I
7 years ago
Solved

Conditional formatting multiple values in a single column

I have a table that has a column with three values - Red, Amber, Green. I want to colour the cells in the table to match the words.   I have tried "Field Value" dialog in Conditional Formatting, bu...
Need Help
  • kennoe's avatar
    kennoe
    7 years ago

    Found the solution. I was pointing the conditional formatting to the column rather than the measure..

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi kennoe

Create a measure

Measure = SWITCH(TRUE(),MAX([Scope])="Green",1,MAX([Scope])="Amber",2,MAX([Scope])="Red",3)

 

 

Best Regards

Maggie

kennoe's avatar
kennoe
Helper I
7 years ago

Thanks Maggie

When i use this formula, I get the same result as my formula ie only the first value is recognised. I tested it on some dummy data and got the same result, only the first value is recognised. 

 

Steve

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    Hi kennoe

    Do you use a measure or a calculated column?

    Could you show me your screenshot about the table and formula, also the setting page of conditional formatting?

     

    Best Regards

    maggie

    • kennoe's avatar
      kennoe
      Helper I
      7 years ago

      Maggie

       

      I used a measure. Refer screenshot.

       

       

      I have set up the conditional formatting as shown below.

      • kennoe's avatar
        kennoe
        Helper I
        7 years ago

        Found the solution. I was pointing the conditional formatting to the column rather than the measure..