# Conditional coloring

Conditional coloring allows you to color cells based on the values in a selected target column.

### **Color style**

* **Color cell background**
* **Color cell text**

### **Use color for entire row**

* **Use color as text or background color of entire row**

### **Target column**

* **Target column:** Select the column that should be used to determine the color of the cells.

### **Conditional coloring for dimensions**

When the target column is a dimension, you assign colors to the individual values of that dimension.

For example, if the target column is **Category**, you can choose a different color for:

* **Furniture**
* **Office Supplies**
* **Technology**

Finance Tables will then use the selected color for cells with that value.

<figure><img src="/files/npY22RTr4uAcMZrIpMDJ" alt=""><figcaption></figcaption></figure>

### **Conditional coloring for measures**

When the target column is a measure, Finance Tables colors the cells based on the numeric value of each cell.

The following settings are available:

* **Below-bounds color**
* **In-bounds color**
* **Above-bounds color**
* **Lower bound**
* **Upper bound**
* **Use a gradient from upper to lower bound**
* **Use custom font color**
* **Custom font color**

Use the lower and upper bounds to define when a value should be treated as below range, in range, or above range.

<figure><img src="/files/AKEOGO6tsLLXFNogbxI7" alt=""><figcaption></figcaption></figure>

<figure><img src="/files/pJI2WaXMOoKJ8oEmNnQo" alt=""><figcaption></figcaption></figure>

**Limitations**

> Conditional coloring is unavailable while an IBCS visualization is enabled for the column.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.infotopics.com/finance-tables/configuration/configuration-screen/data-tab/conditional-coloring.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
