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