QuickSight Conditional Formatting and Multi-Column Sorting

1. Create two parameters - thresholdGreen and thresholdRed.

2. Create Controls for these two parameters as slider type - Threshold_Green and Threshold_Red with Min = 0, Max = 100, Step =1.

3. Create calculated field "threshold" like this

   ifelse(test <= ${thresholdGreen},0,test >= ${thresholdRed},2,1)

4. On "error" field, right click and create conditional formatting like follows:

   Format field based on = "threshold"
   
   Aggregation = "No aggregation"
   

   Condition #1 Equals 0 ; Color = green

   Condition #2 Equals 1; Color = amber

   Condition #3 Equals 2; Color = red

5. Apply.

Now you can change conditional formatting dynamically with the controls you created.

Hopefully, you can achieve what you described.