Conditionally Format a Switch Measure in Matrix

[Yoshimitsu411]

Hello

I followed a very helpful article to create the switch measures below. 

Header Measure Order = 
    Max('Matrix Headers'[Order])

Header Measure Value = 
SWITCH([Header Measure Order],
    1, [Actuals],
    2, [Budget],
    3, [Purchases],
    4, [Sales],
    5, [Sample 1],
    6, [Sample 2]
)

What I would like to do is condinally format the measure. When Actuals > Budget show the Actuals value in Green and Budget in Red. Same for Purchases and Sales and so on.

I have tried using Field Value but it changes the colours for all the values and not individually in the matrix.

Thank you for any help.

Yoshi

[Yoshimitsu411 · Accepted solution]

Nevermind, I solved it.

Format Table =

SWITCH([Header Measure Value],

    [A Actuals],

        SWITCH(TRUE(),

            [A Actuals] > [B Budget], "#3CB371", "#FF6347"

        ),

    [B Budget],

        SWITCH(TRUE(),

            [B Budget] > [A Actuals], "#3CB371", "#FF6347"

        ),

    "#FF6347"

    )