> For the complete documentation index, see [llms.txt](https://videos.inforiver.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://videos.inforiver.com/reporting-matrix/conditional-formatting.md).

# Conditional formatting

<table data-header-hidden><thead><tr><th width="330"></th><th></th></tr></thead><tbody><tr><td><a href="/reporting-matrix/conditional-formatting/one-click-options.md">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="/reporting-matrix/conditional-formatting/semantic-formatting.md">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="/reporting-matrix/conditional-formatting/heat-map-formatting.md">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="/reporting-matrix/conditional-formatting/format-entire-row.md">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="/reporting-matrix/conditional-formatting/traffic-light-and-arrow-alert.md">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="/reporting-matrix/conditional-formatting/fill-icon-and-star-rating.md">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="/reporting-matrix/conditional-formatting/segmentation.md">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="/reporting-matrix/conditional-formatting/format-top-bottom-n-rows.md">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="/reporting-matrix/conditional-formatting/branch-level-formatting.md">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="/reporting-matrix/conditional-formatting/conditional-formatting-of-multiple-hierarchies.md">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="/reporting-matrix/conditional-formatting/dynamic-conditional-formatting.md">Dynamic conditional formatting </a>(01:59)</td><td>Highlight cells based on a dynamic cell selection</td></tr><tr><td><a href="/reporting-matrix/conditional-formatting/format-using-if-conditions.md">Format using if conditions</a> (02:33)</td><td>Easily apply conditional formatting based on IF conditions </td></tr></tbody></table>


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

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

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://videos.inforiver.com/reporting-matrix/conditional-formatting.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

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.