How to set Color Threshold rules depends on specific value/string

I have problem with setting threshold rules for my table and I don’t know how to resolve my problem.

I have table with KPI’s results (like on example below) and I want to set color thresholds depend on KPI type.

I want to set a rules for color thresholds like on example depend on what sign is in Target Type column. Color should be applied to column “Results”

In simple words…

  • Accuracy and Precision should be more green if value is higher.
  • False Positive and False Negative should be more green if value is lower

I tried to use Override rules but I am not sure if it is even possible to set a rules to specific column based on content of different column.

Someone maybe know how to do it?

Best regards,