---
schema_version: "1"
id: ee81531c79389ca285eceb12ce29ac1ec5e0c7a1fce652a7c8fea5c882ee2a79
title: Highlight Repeater Widget Content with Conditional Formatting
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_dashboard_repeater_widgets_conditionalformatting.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_dashboard_repeater_widgets_conditionalformatting.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: c19c28679d078d2365d3897fb23876b77762d90039c3b6149b0192bf2ea43f95
description: Make key data in repeater widgets stand out by adding conditional formatting rules to text, numbers, charts, or images. For example, highlight countries with opportunity amounts less than 3 million dollars in the Opportunities dashboard that’s set up with a repeater. You can apply the same rule or a separate one for each widget in the repeater based on a value or range.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Highlight Repeater Widget Content with Conditional Formatting

Make key data in repeater widgets stand out by adding conditional formatting rules to text, numbers, charts, or images. For example, highlight countries with opportunity amounts less than 3 million dollars in the Opportunities dashboard that’s set up with a repeater. You can apply the same rule or a separate one for each widget in the repeater based on a value or range.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small permission">
        <colgroup>
          <col style="width:50%">
          <col style="width:50%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="text-align:center;vertical-align:top;" id="d73960e36">User Permissions
              Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d73960e36 ">To customize dashboard widgets:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d73960e36 ">Create and Edit Analytics Dashboards</td>

          </tr>
        </tbody>
      </table>

1. In the dashboard designer, with the repeater widget selected, click **Edit Repeater Content**.
    
    ![Editing a repeater widget and query](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_edit_repeater_widget_Cf.png)
2. In the repeater widget, select the widget that you want to add the conditional formatting rule to and, and then under Conditional Formatting, click **Add Rule**.
    
    ![Adding a conditional formatting rule to repeater widget](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_repeater_widget_addrule.png)
    
    To add a rule to an existing text widget in the repeater, modify the dashboard JSON.
3. Select the reference column (1) to base the conditional formatting rule on and the coloring method (2) to use.
    
    ![Setting reference column and coloring method to the conditional formatting rule](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_repeater_cf_panel.png)
    
    The reference column’s data type determines the available coloring method options. For example, when the reference column is a measure or a derived measure, you can base the coloring method on a range (bins). When the reference column is a dimension, you can base the coloring method on the dimension value or the reference column’s color style.
4. Use a similar process to apply conditional formatting rules to other widgets in the repeater widget.
    
    To include symbols or custom images with conditional formatting rules, add an image widget to the repeater. For example, use ![Down arrow symbol](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_symbol_downarrow.png) to indicate opportunity amounts less than 3 million dollars in the repeater widget.
    
    ![Symbols palette in Dashboard Conditional Formatting Rules](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_cf_symbols.png)
5. Preview your changes and save your dashboard.
    
    ![Dashboard with conditional formatting rule in repeater widgets](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_cf_dashboardresults.png)