Trying to format individual values in a matrix table

Hi HDD328 

For your question, here is the method I provided:

Here's some dummy data

“LossByCodeActual”

“LossByCodeTargets”

Create a measure.

OilLightsFormatting = 
var _code = SELECTEDVALUE('LossByCodeActual'[Loss By Code])
RETURN
IF(
    SUM('LossByCodeActual'[Values]) > 
    LOOKUPVALUE('LossByCodeTargets'[Values], 'LossByCodeTargets'[Loss By Code], _code), 
    "Red", 
    "Green"
)

Here is the result.

Regards,

Nono Chen

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