---
title: "Use a Range Data Control to Set Color Thresholds for Grids"
slug: "use-a-range-data-control-to-set-color-thresholds-for-grids"
updated: 2026-02-23T09:04:00Z
published: 2026-02-23T09:04:00Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://documentation.lakesidesoftware.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Use a Range Data Control to Set Color Thresholds for Grids

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.

![](https://cdn.document360.io/87d11426-6b1f-4b19-b593-b71e55a81af3/Images/Documentation/range_grid_exmple.png)

1. [Set up values and parameters for the range control.](/documentation/docs/set-up-values-and-parameters-for-a-range-control)
2. Connect the Range Control Block to retrieve inputs from a Query Data Block, and output to a Grid block.
3. Select the Range Data Control block.
4. In the **Properties** section, select the Grid as the **Pane** in which the range slider should appear.
5. If you do not want the user to be able to change the color ranges, check the **Hide Slider** option.
6. Set up either a [basic color gradient](/documentation/docs/set-up-a-basic-color-gradient-using-a-range-control), or [set up a 3-color gradient](/documentation/docs/set-up-a-3-color-gradient-using-a-range-control).
7. Select the Grid block and open the **Input Bindings** section.
8. In the **Column Properties**section of the Grid Properties, select the column to be color coded from the drop-down list.

![](https://cdn.document360.io/87d11426-6b1f-4b19-b593-b71e55a81af3/Images/Documentation/range_column_properties.png)
9. In the **Data color** drop-down list, select the thresholds output from the Range Control block.
10. 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**.
11. 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.
12. When you are done, click the **Apply** button.