Conditional formatting based on 2 columns

[mofai]

Hi All,

Conditional formatting based on 1 column field and calculated measure

i m trying to implement a conditional formatting, to change the background color of a matrix cell.

My code is 

Condition_first_reply_time_50 = SWITCH(TRUE();
FactTickets[requesttyp]="question" && [First Reply Time (hrs)50%] >= 8; "Red";
FactTickets[requesttyp]="change" && [First Reply Time (hrs)50%] >= 8; "Red";
FactTickets[requesttyp]="service" && [First Reply Time (hrs)50%] >= 8; "Red";
FactTickets[requesttyp]="incident" && [First Reply Time (hrs)50%] >= 4 ; "Red";
"#83BC00")

21.7  -> is green

but it didnt work , i dont know why, by question , value of 21.7 i got the wrong color (green), should be red.

Thanks for your help!

[v-yulgu-msft]

Hi @mofai ,

I tested with above formula, it set conditional colors as expected.

Best regards,

Yuliana Gu