Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Unichar code color based on text condition

Hi, I have a Column with this UNICHAR Code 

UNICHAR(11044)
 
I need this circle to have different colors deppending on text values from another columns (I have the RAG colors as text and also I have code colors)
 
which is the best way to put colors in the circle in a Matrix table, using conditional formatting?
 
Thanks
  • Hi, Anonymous 

     

    You may make the visual selected, click 'Scorecard Light'=>'Conditional Formatting'=>'Font Color', format by field value, set as below.

     

    Result:

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • v-alq-msft's avatar
    v-alq-msft
    Community Support

    Hi, Anonymous 

     

    You may make the visual selected, click 'Scorecard Light'=>'Conditional Formatting'=>'Font Color', format by field value, set as below.

     

    Result:

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • az38's avatar
    az38
    Community Champion

    Hi Anonymous 

    try to use conditional formating, set Font color by Field value, based on your Original Scorecard field