# One click rules for tables In this section, we'll discover the single-click conditional formatting options for tables. Selecting a single-click rule will open the Conditional Formatting side pane. By default, single-click rules will use the AC (Actuals) measure. The configurations are automatically set but you can modify them as required. We'll learn more about configuring rules in later sections. ### 1. Value You can highlight positive/negative values using this option. You can also set a threshold and highlight values that are lesser or greater than the custom threshold. In this example, we chose the **Negative** rule and modified the condition to use variance instead of the default AC measure.

Conditional formatting applied to highlight AC where variance is negative

### 2. Comparison value You can use the comparison value option to quickly highlight data based on comparing 2 columns. Analytics+ offers two methods to highlight data based on column comparisons: * Greater/less than a benchmark * Ranges #### 2.1. Greater/less than benchmark You can highlight values with a single color when the measure is greater or lesser than the benchmark measure. In the table, we have used the **Greater than benchmark** to highlight the AC values when AC > PL, the PL measure being the benchmark.

#### 2.2 Ranges You can use a heatmap to highlight values when the benchmark measure falls within a specified range. Analytics+ dynamically calculates the range - enabling you to apply conditional formatting in a single click. You can also override the pre-calculated ranges and specify custom values. We have used the **Ranges** option to highlight the AC values based on the variance from the Plan.

### 3. Color scales Based on your data, you can apply different color scales: sequential, qualitative, and diverging. When a heatmap is used, the font colors are automatically adjusted to be in contrast with their backgrounds for enhanced readability. {% hint style="info" %} For Inforiver to automatically adjust the font color, enable the Canvas > Auto color property. {% endhint %} In the table, we've used a sequential heatmap for the AC measure.

The minimum and maximum values to determine the value ranges can be calculated at an individual panel or table level. Choose the **Column wise** option to calculate the minimum and maximum values for each panel and set the color scale within each panel. Choose the **Table wise** option to apply the heatmap based on the minimum and maximum values in the entire table.

--- # 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.inforiver.com/analytics+/working-with-analytics+/9.-conditional-formatting/one-click-rules/one-click-rules-for-tables.md?ask= ``` 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.