You can use a Range Data Control to color code a column in a grid and allow users to optionally change the threshold as shown in the example below.
Connect the Range Control Block to retrieve inputs from a Query Data Block, and output to a Grid block.
Select the Range Data Control block.
In the Properties section, select the Grid as the Pane in which the range slider should appear.
If you do not want the user to be able to change the color ranges, check the Hide Slider option.
Set up either a basic color gradient, or set up a 3-color gradient.
Select the Grid block and open the Input Bindings section.
In the Column Properties section of the Grid Properties, select the column to be color coded from the drop-down list.
In the Data color drop-down list, select the thresholds output from the Range Control block.
Once you have selected a Data color option the Color value column will display a list of all available numeric columns to use to calculate the color. If the current column is numeric, this will be selected by default as the Color value column.
If the current column is non-numeric, select a numeric column from the Column value column field drop-down list on which to base the color-coding value.
When you are done, click the Apply button.