Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Conditional Formatting for Min/Max Values in Matrix

Hi,   I am needing to conditionally format the values in this table to show with red font color if it is the lowest value within the quarter and green font color if it is the highest value within t...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    This is the measure I ended up using and it worked perfectly as you can see below. (The table was slightly renamed since the original posting of this question.)

     

    Here is the output, just as desired: (Q2 FY21 is now included as time has passed and the financials were finalized.) The numbers blacked out were excluded from the formatting by using the filters in the measure.

     

MFelix's avatar
MFelix
Super User
5 years ago

Hi Anonymous ,

 

To use color codes in measures tyou need to have the codes with an hashtag and the six digit code, on the first colour you only have "FF0000" you need to had the # so it would bve "#FF0000".

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hello MFelix,

 

Thanks for the tip. I fixed this small error, and this measure is still greyed out when I try to select it as the 'Based on value' in conditional formatting. Any ideas on what to do now?