# Conditional formatting

<table data-header-hidden><thead><tr><th width="330"></th><th></th></tr></thead><tbody><tr><td><a href="/pages/cOVIeNJPaIKWmGmpBjJW">One-click options</a> (05:33)</td><td>Highlight specific performance areas using one-click options such as quick rule, color scales, classifications, and data bars</td></tr><tr><td><a href="/pages/wg3LiRGAc5U4mRQqspoW">Semantic formatting</a> (01:13)</td><td>Format positive and negative numbers using colors and indicate negative values with "-" or "()"</td></tr><tr><td><a href="/pages/7jfFVH9lbXks614QzhNq">Heat map formatting</a> (02:29)</td><td>Apply color scales such as sequential, qualitative, diverging in a single-click</td></tr><tr><td><a href="/pages/eokygzN6FQQvdjF5WI9E">Format entire row</a> (01:56)</td><td>Apply formatting to entire rows or row headers, based on your requirements</td></tr><tr><td><a href="/pages/vKOMStZOQ1XHiUTvergE">Traffic light &#x26; arrow alert </a>(02:40)</td><td>Apply traffic light icons based on predefined ranges and customize icons/colors </td></tr><tr><td><a href="/pages/FFqQtMz8fsw6LitcAwsY">Fill icon and star rating </a>(01:48)</td><td>Highlights values with circle fill and star rating icons based on ranges, with custom options</td></tr><tr><td><a href="/pages/3bWQ860MqefbCGb77zC2">Segmentation</a> (02:27)</td><td>Perform analysis such as ABC analysis and create segments based on text, ratings or icon sets </td></tr><tr><td><a href="/pages/iPfByMeFSoGmrSavwvOr">Format top/bottom N rows</a> (01:19)</td><td>Highlight top/bottom performers in reports with Inforiver's customizable conditional formatting</td></tr><tr><td><a href="/pages/NXGGpvM5Vb8Oie0gs477">Branch level formatting</a> (03:16)</td><td>Apply different conditional formatting rules to different branches in a hierarchy</td></tr><tr><td><a href="/pages/bsh5yUqdgMNtvrITTY9P">Conditional formatting of multiple hierarchies</a> (01:39)</td><td>Learn to highlight different levels in a hierarchy  based on rules without affecting totals</td></tr><tr><td><a href="/pages/SzWTQDMI1dYon6GT4XXN">Dynamic conditional formatting </a>(01:59)</td><td>Highlight cells based on a dynamic cell selection</td></tr><tr><td><a href="/pages/9ShzGSQtDjBG4D8wIc3X">Format using if conditions</a> (02:33)</td><td>Easily apply conditional formatting based on IF conditions </td></tr></tbody></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://videos.inforiver.com/reporting-matrix/conditional-formatting.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.
