conditional formatting not applying

Thank you. Both solutions work.


I ignored the 'percent' selection as it was grayed out so didnt expect it to be doing anything. 

However, changing the 'appy to' option to Values, not Values and Totals makes it available again.  
I could then change it to 'number'.
Changing back to values and totals then worked and displayed the correct colour. 

You could try it with a measure that returns the color you want instead, like this.

2020 Average Rating Color =
SWITCH (
    [2020 Average Rating],
    "Bronze", "#6A3805",
    "Silver", "#B4B4B4",
    "Gold", "#C9B037",
    "Unrated", "#B70000"
)

Make sure the measure is formatted as text and apply the conditional formatting based on a field value.