# Value color

The action will set the font color, background color or border color by using the measure value and the one of the predefined algorithms: “Positive/Negative”, “Less than 100%”, “Heatmap”.

{% hint style="info" %}
This action can be applied on a cell linked with the dimension or measure
{% endhint %}

Choose "Font color", "Background color", "Line" or "Symbol" to apply selected algorithm on particular property. Font or background color can be set for particular cell with the help of the action.  In case of the "Line" property a border color will be set  with the help of the action (if the borders were applied on the cell). The icon color can be set by selecting "Symbol" value.

###

### Positive/Negative

![](/files/-LbX-UXhS2IXBsk98WuB)

Choose colors for “Positive” and “Negative” parameters by clicking the corresponding button <img src="/files/-LbX1nd-qpDcp2H7owid" alt="" data-size="original"> or  <img src="/files/-LbX1crZF4XJq-tMDZOY" alt="" data-size="original">

All positive and negative values will be colored in the selected colors.

### &#xD;&#x20;

### **Less than 100%**

![](/files/-LbX1JN1QChC-4vFv0Vz)

Choose colors for “Less than 100%” and “otherwise” parameters by clicking the corresponding button <img src="/files/-LbX1nd-qpDcp2H7owid" alt="" data-size="original"> or  <img src="/files/-LbX1crZF4XJq-tMDZOY" alt="" data-size="original">

The color will be applied on a cell with a measure depending on the measure value: if it is less,  greater or equal to 1.

### Heatmap

![](/files/-LbX39AH1IIZ6OXpQB5w)

Applies one of the predefined heatmap color schemes.

With the help of “Custom” option you will be able to change "Min", "Average" and/or "Max" parameters and specify colors for minimum, average and maximum values. It allows building custom heatmap color schemes.

### Text color expression

This option allows to set a "Font color", "Background color", "Line" or "Symbol" color by using the "Text color expression" for a measure. It has no parameters.


---

# 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://help.rbcgrp.com/actions/value-color.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.
