# Conditional Formatting

Conditional formatting lets you color code specific words based on a set of rules. You can create rule based on category or measure data.

## Steps to apply conditional formatting?

1. Go to conditional formatting, using advanced settings.
2. Click on the “Add Rule” button. *\[Rule name is mandatory to have.]*
3. Apply rule to the measure or category.
4. Pick to column from the dropdown menu.
5. Create a condition and select the custom color.
6. Hit save, to apply.

Result: If the conditions are the met, the colors will be visible on the word cloud.

<figure><img src="/files/RJCddiFJDDdKDEAx4VaQ" alt=""><figcaption><p>IMAGE – ABOUT STEPS ON HOW TO APPLY CONDITIONAL FORMATTING</p></figcaption></figure>

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

## Measure Rule

You can set rules based on any numeric value in this section. Measure field and tooltip values can be used to apply conditions. Measure rules can be defined by equal to, not equal to, less than, greater than.

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

## Category Rule

You can set rules based on dimension in this section. For categories, rules can be set by is, is not, begins with, does not begin with, ends with, does not end with, contains, does not contain.

{% hint style="info" %}
Note: When there is no measure added into measure filed, then in that case you can only apply conditional formatting based on Category is present.
{% endhint %}

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


---

# 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.powerviz.ai/powerviz/word-cloud/advanced-settings-introduction/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.
