Skip to main content

 

ThoughtSpot

Apply conditional formatting to a table

Overview

Explains what the feature is or what its benefits are to the user or customer.

Feature

You can use conditional formatting to show table cells with a background color determined by the value they contain.

To apply conditional formatting to a table:

  1. In the column header of your table for the column you want to apply formatting to, click the three dot Change Configuration icon.
    File:01_The_Basics/end_user_guide_bookmap/020/020/020/040/070/010/conditional_formatting_table_1.png

    Three dot menu

  2. Select Conditional Formatting.
  3. Click the + icon in the Conditional Formatting menu.
    File:01_The_Basics/end_user_guide_bookmap/020/020/020/040/070/010/conditional_formatting_table_2.png

    Conditional formatting menu

  4. Define the sets of values and the color to use for each set.
    File:01_The_Basics/end_user_guide_bookmap/020/020/020/040/070/010/conditional_formatting_table_3.png

    Define the sets of values and color

  5. Click Done after defining all of your conditional formatting sets.
    File:01_The_Basics/end_user_guide_bookmap/020/020/020/040/070/010/conditional_formatting_table_4.png

    Table with conditional formatting

  6. Note that if you change to a chart type, you will need to apply conditional formatting again. Conditional formatting is tied to the specific visualization.
 

Conditional formatting video

  • Was this article helpful?