I'd probably break this into two parts.
First, a formula to determine if the month exceeds the thresholds and if so returns the DATE.
Months Meeting Threshold =
IF [OUT % of Total] < .1 AND [APP % of Total] < .1 AND [AWD % of Total] < .1 THEN [Month] END
Second, a table calc to find the LAST() value in the above formula and compares that to the month on the row.
Recovery Rate End Month =
MIN([Month]) == LOOKUP(MIN([Months Meeting Threshold]), LAST())
Now you can drop Recovery Rate End Month on the color shelf and it will evaluate to TRUE only for the last month.
ColorLastRow.twbx.zip 13.6 KB