how to make text Font colour should be white when black ground colour red ?

[Paulyeo11]

Hi All

Below is my script for make font colour white when text black ground colour red.

Color Text Target =

VAR _variance_per_country =

[Target Vari %]

RETURN

SWITCH (

TRUE (),

_variance_per_country < 0 && _variance_per_country >= -100, "#edebeb", //#D64550 TEST #edebeb

_variance_per_country <= 10 && _variance_per_country >=0, "#0d0d0d",

"#00000"

)

Below is the result not correct , due to above script 

Can some one share with me where go wrong ?

Paul

[v-easonf-msft]

Hi， @Paulyeo11 

Could you please tell me if your problem has been solved?

For now, there is no content of description in the thread. If you still need help, please share more details to us.

Best Regards,
Community Support Team _ Eason

[v-easonf-msft · Accepted solution]

Hi, @Paulyeo11 

I tested your measure  on my side  and it seems that no errors were found.

Please recheck whether you have used the corresponding conditional format.

Best Regards,
Community Support Team _ Eason