> ## Documentation Index > Fetch the complete documentation index at: https://insightsoftware.mintlify.site/llms.txt > Use this file to discover all available pages before exploring further. # Use the Conditional Formatting Sidebar > You can format tables by information contained in the tables for ease of use. Format your visuals by adding color and text formats based on the conditions you define. A sidebar menu work area, Conditional Formatting, allows you to set format conditions to apply to your data. Control user access to Conditional Formatting by enabling or disabling the Conditional Formatting on the interactivity panel for a visual, a visual in a dashboard, or the table visual that is used as a self service report.. displays a warning icon if you try to create a conditional formatting rule for tables that include a field or group not present in the visual. The resulting rule will not include the missing field or group. For more information about conditional formatting, see the following topics: * [Configure Conditional Formatting](#configure-conditional-formatting) * [Using the Conditional Formatting Sidebar - Tables](#using-the-conditional-formatting-sidebar-tables) * [Using the Conditional Formatting Sidebar - Pivot Tables](#using-the-conditional-formatting-sidebar-pivot-tables) * [How Self-Service Analytics Applies Formatting Rules](#how-self-service-analytics-applies-formatting-rules)

How Self-Service Analytics Applies Formatting Rules

You can apply formatting rules to data affected by multiple conditions. The formatting rules are applied sequentially, and can cancel out a previously applied rule. For example, if you define the background row color for orders from Florida to appear green, but define the background row color for orders that fall within a certain threshold to appear blue, the final result will depend on the order in which you organize your format rules. The blue background rule overrides the green background rule In the above example, formatting based on the **State** condition is applied first, then formatting based on the **Actualsales** condition overrides that rule. In the above example, formatting based on the **Actualsales** condition is applied first, then formatting based on the **State** condition overrides that rule. Mix and match rules as needed to achieve the look and feel you want.

Using the Conditional Formatting Sidebar - Tables

Format your visuals by adding color and text formats based on the conditions you define. A sidebar menu work area, Conditional Formatting, allows you to set format conditions to apply to your data. displays a warning icon if you try to create a conditional formatting rule for tables that include a field or group not present in the visual. The resulting rule will not include the missing field or group. 1. Select the visual in the Visual Gallery, a self service report, or on a dashboard. Open the [sidebar menu](/simba-embedded-analytics/docs/self-service-analytics/26.3/analyze-data/visuals/visual-setup#use-the-visual-sidebar-menu). 2. Select the conditional formatting option . The Conditional Formatting sidebar opens. Use to create conditional formatting rules 3. Use this work area to configure formatting options for your table visuals or the table visual of a self service report. 4. After making changes, select **Apply** to apply the conditional formatting rules you have specified. 5. Save the visual, self service report, or dashboard to save your changes.

Conditional Format Options

The available options for rules and formatting change to reflect your selections.

Conditional Formatting Sidebar

* Select **Add Rule** to add a conditional formatting rule. * Select an existing rule to edit the rule, or the delete icon to delete the rule. * Select and drag rules to change their order.

Add or Edit Conditional Formatting Rule

Select When To Apply Formatting

Select the add icon add icon in **Select When To Apply Formatting** to define the conditions to apply your formatting.

Select Where To Apply Formatting

Enable **Format entire row** in **Select Where To Apply Formatting**to format the entire row. Disable to format only the applicable cell. Select the add icon add icon for **Formatting** to define the formatting for your condition. Select the delete icon to delete a formatting option.

Select When To Apply Formatting

* **Row** attribute: Select a row attribute to define the values for formatting by this data. Optionally, select the add icon add icon to add a derived field or custom metric. Example: Apply a background color to a specific **State** condition. example of conditional formatting by row attribute * **Group** attribute: Select an attribute that you’ve grouped your data by to define values for that aggregated data. Optionally, select the add icon add icon to add a derived field or custom metric. Example: Format Group attributes that meet the condition: the `Sum` of **Actualsales** grouped by **Product** `Between` a defined range of values. example of formatting applied to a group condition #### Select Values for an Attribute
Selection Description
Operator Select **Include** to include the selected values for this attribute.
Select **Exclude** to exclude the selected values for this attribute.
Customize Enter a custom value and select **Add** to add it to the values list.
Select the delete icon to remove it from the values list.
Search Search for specific values in your list.
Select All Select the checkbox to include all listed values.
Clear the checkbox to remove all selected values.

Select Values for a Number

Selection Description
Range Displays the range for this value.
Operator Select an operator to use.
Options may include **Between**, **Not Between**, **Equal**, **Not Equal**, **Greater Than**, **Greater Than** or **Equal**, **Less Than**, **Less than or Equal**, **Include**, and **Exclude**.
Depending on the Operator you select, different definition fields are available to use.
From, To Define a value range for **Between**and **Not Between**.
Value Define a value for **Equal**, **Not Equal**, **Greater Than**, **Greater Than** or **Equal**, **Less Than**, and **Less than or Equal**.
Customize Optionally define for **Include**, and **Exclude**.
Enter a custom value and select **Add** to add it to the values list.
Select the delete icon to remove it from the values list.
Search For **Include**, and **Exclude**. Search for specific values in your list.
Select All Define for **Include**, and **Exclude**.
Select the checkbox to include all listed values.
Clear the checkbox to remove all selected values.
#### Select Values for a Date
Selection Description
Range Displays the range for this value.
Operator Select an operator to use.
Options may include **Between**, **Is NULL**, and **Is not NULL**.
Depending on the Operator you select, different definition fields are available to use.
From, To Define a value range for **Between**, using **Static Time** or **Dynamic Time**. See [Set a Time Field Filter](/simba-embedded-analytics/docs/self-service-analytics/26.3/analyze-data/filters/filters-attr#set-a-time-field-filter).
Presets ... Select an available **Preset...** for **Between**.
See [Set a Time Field Filter](/simba-embedded-analytics/docs/self-service-analytics/26.3/analyze-data/filters/filters-attr#set-a-time-field-filter).

Formatting

Select the add icon add icon to add a formatting option you will apply to your condition. Select the delete icon to remove the formatting option.
Format Option Description
Text Color Select to define the text color format to apply to your condition.
Enter the color number in hexadecimal, or use the color picker to enter RGB values or pick your color visually.
Background Color Select to define the background color to apply to your condition.
Enter the color number in hexadecimal, or use the color picker to enter RGB values or pick your color visually.
Bold Select to enable or disable bold formatting to apply to your condition.
Italic Select to enable or disable italic formatting to apply to your condition.
Underline Select to enable or disable underline formatting to apply to your condition.
In the above example, formatting based on the **Actualsales** condition is applied first, then formatting based on the **State** condition overrides that rule. Mix and match rules as needed to achieve the look and feel you want.

Using the Conditional Formatting Sidebar - Pivot Tables

Format your visuals by adding color and text formats based on the conditions you define. A sidebar menu work area, Conditional Formatting, allows you to set format conditions to apply to your data. You're not limited to formatting information based on data represented in the table, you can create conditional formatting rules based on any data available in the source that is the basis of the pivot table. 1. Select the pivot table visual in the Visual Gallery or on a dashboard. 2. If you selected the visual on a dashboard, select **Settings** on the [visual drop-down menu](/simba-embedded-analytics/docs/self-service-analytics/26.3/analyze-data/visuals/visual-setup#use-the-visual-drop-down-menu) to access the [sidebar menu](/simba-embedded-analytics/docs/self-service-analytics/26.3/analyze-data/visuals/visual-setup#use-the-visual-sidebar-menu) for the visual. 3. Select the conditional formatting option on the [sidebar menu](/simba-embedded-analytics/docs/self-service-analytics/26.3/analyze-data/visuals/visual-setup#use-the-visual-sidebar-menu) for the visual. The Conditional Formatting sidebar opens. Use to create conditional formatting rules 4. Using the Conditional Formatting sidebar, you can configure formatting options for your pivot table visuals. See [Configure Conditional Formatting](#configure-conditional-formatting). 5. After making changes, select **Apply** to apply the conditional formatting rules you have specified. 6. Save the visual or dashboard to save your changes.

Conditional Format Options

The available options for rules and formatting change to reflect your selections.

Conditional Formatting Sidebar

* Select **Add Rule** to add a conditional formatting rule. See [Configure Conditional Formatting](#configure-conditional-formatting). * Select an existing rule to edit the rule, or the delete icon to delete the rule. * Select and drag rules to change their order.

Add or Edit Conditional Formatting Rule

Select When To Apply Formatting

Select the add icon add icon in **Select When To Apply Formatting** to define the conditions to apply your formatting.

Select Where To Apply Formatting

Select the add icon add icon for **Formatting** to define the formatting for your condition. Select the delete icon to delete a formatting option.

Select When To Apply Formatting

**Group** attribute: Select a group of data to define values for that aggregated data. Optionally, select the add icon add icon to add a derived field or custom metric. Example: Format Group attributes that meet the condition: the `Range` of **Volume** grouped by **Income Bracket** is `Between` a defined range of values. example of formatting applied to a group condition #### Select Values for a Custom Metric
Selection Description
Values Select a range of values to format. Options include:
* **Cell Value** - format the data based on the value of the cell. * **Row Total** - format the data based on the value of the row total. * **Column Total** - format the data based on the value of the column total.
Operator Select an operator to use. Options may include **Between**, **Equal**, **Not Equal**, **Greater Than**, **Greater Than or Equal**, **Less Than**, and **Less than or Equal**. Depending on the Operator you select, different definition fields are available to use.
From, To Define a value range for **Between**.
Value Define a value for **Equal**, **Not Equal**, **Greater Than**, **Greater Than** or **Equal**, **Less Than**, and **Less than or Equal**.

Select Values for a Number

Selection Description
Range Displays the range for this value.
Values Select a range of values to format. Options include:
* **Cell Value** - format the data based on the value of the cell. * **Row Total** - format the data based on the value of the row total. * **Column Total** - format the data based on the value of the column total.
Aggregation Select an aggregation option for Values. Options include **Avg**, **Min**, **Max**, **Sum**, **Count**, **Distinct Count**, and **Last Value**.
Operator Select an operator to use. Options may include **Between**, **Equal**, **Not Equal**, **Greater Than**, **Greater Than or Equal**, **Less Than**, and **Less than or Equal**. Depending on the Operator you select, different definition fields are available to use.
From, To Define a value range for **Between**.
Value Define a value for **Equal**, **Not Equal**, **Greater Than**, **Greater Than** or **Equal**, **Less Than**, and **Less than or Equal**.
#### Select Values for Count Of
Selection Description
Values Select a range of values to format. Options include:
* **Cell Value** - format the data based on the value of the cell. * **Row Total** - format the data based on the value of the row total. * **Column Total** - format the data based on the value of the column total.
Aggregation Select an aggregation option for Values. Options include **Count**and **Distinct Count**.
Operator Select an operator to use. Options may include **Between**, **Equal**, **Not Equal**, **Greater Than**, **Greater Than or Equal**, **Less Than**, and **Less than or Equal**. Depending on the Operator you select, different definition fields are available to use.
From, To Define a value range for **Between**.
Value Define a value for **Equal**, **Not Equal**, **Greater Than**, **Greater Than or Equal**, **Less Than**, and **Less than or Equal**.

Formatting

Select the add icon add icon to add a formatting option you will apply to your condition. Select the delete icon to remove the formatting option.
Format Option Description
Text Color Select to define the text color format to apply to your condition.
Enter the color number in hexadecimal, or use the color picker to enter RGB values or pick your color visually.
Background Color Select to define the background color to apply to your condition.
Enter the color number in hexadecimal, or use the color picker to enter RGB values or pick your color visually.
Bold Select to enable or disable bold formatting to apply to your condition.
Italic Select to enable or disable italic formatting to apply to your condition.
Underline Select to enable or disable underline formatting to apply to your condition.
In the above example, formatting based on the **Actualsales** condition is applied first, then formatting based on the **State** condition overrides that rule. Mix and match rules as needed to achieve the look and feel you want.

Configure Conditional Formatting

Format your tabular visuals and self service reports by adding color and text formats based on the conditions you define. The Conditional Formatting sidebar allows you to set formatting based on conditions to apply to your data. ### Define Conditional Formatting for Table Visuals 1. Select a table visual in a dashboard, a self service report, or the Visual Gallery. 2. Select the conditional formatting icon in the sidebar menu. The Conditional Formatting sidebar opens. Add conditional formatting rules here 3. Select **Add** to open the add rule work area. Use this work area to define a condition and the formatting to apply. define conditions and formatting to apply to tables 4. Select the add icon add icon in **Select When To Apply Formatting** to define the conditions to apply your formatting. See [Using the Conditional Formatting Sidebar - Tables](#using-the-conditional-formatting-sidebar-tables). Select an attribute to define a condition Select a row or group attribute. The Value work area opens. Define the values for this condition. See Use the Conditional Formatting Sidebar. Select the values formatting will apply to here Select **Continue** to save your changes and define the formatting options. 5. Optionally, enable **Format entire row** in **Select Where To Apply Formatting** to format the entire row. Disable to format only the applicable cell. 6. Select the add icon add icon for **Formatting** to define the formatting to apply to data that matches the condition you set. See Use the Conditional Formatting Sidebar. define the formatting to apply to your selected attribute Select a formatting option and define the look you need. See Use the Conditional Formatting Sidebar. 7. Optionally, add as many formatting options as you need. Formats are applied sequentially: see [How Self-Service Analytics Applies Formatting Rules](#how-self-service-analytics-applies-formatting-rules). Select the delete icon to remove any unneeded options. Select **Continue** to save your changes. 8. Optionally, add more conditional formatting rules. Drag and drop the rules change their order. In a case where multiple formatting rules apply to results of overlapping conditions, formats are applied sequentially. See Use the Conditional Formatting Sidebar. add, remove, or edit rules as needed 9. Select **Apply** to apply your changes to the visual. ### Define Conditional Formatting for a Pivot Table Visual 1. Select a table visual in a dashboard or in the Visual Gallery. 2. Select the conditional formatting icon in the sidebar menu. The Conditional Formatting sidebar opens. Add conditional formatting rules here 3. Select **Add** to open the add rule work area. Use this work area to define a condition and the formatting to apply. define conditions and formatting to apply to pivot tables 4. Select the add icon add icon in **Select When To Apply Formatting** to define the conditions to apply your formatting. See [Using the Conditional Formatting Sidebar - Pivot Tables](#using-the-conditional-formatting-sidebar-pivot-tables). Select an attribute to define a condition Select a group attribute. The Value work area opens. Define the values for this condition. See Use the Conditional Formatting Sidebar. Select the values formatting will apply to here Select **Continue** to save your changes and define the formatting options. 5. Select the add icon add icon for **Formatting** to define the formatting to apply to data that matches the condition you set. See Use the Conditional Formatting Sidebar. define the formatting to apply to your selected attribute Select a formatting option and define the look you need. See Use the Conditional Formatting Sidebar. 6. Optionally, add as many formatting options as you need. Formats are applied sequentially: see [How Self-Service Analytics Applies Formatting Rules](#how-self-service-analytics-applies-formatting-rules). Select the delete icon to remove any unneeded options. Select **Continue** to save your changes. 7. Optionally, add more conditional formatting rules. Drag and drop the rules change their order. In a case where multiple formatting rules apply to results of overlapping conditions, formats are applied sequentially. See Use the Conditional Formatting Sidebar. add, remove, or edit rules as needed 8. Select **Apply** to apply your changes to the visual.