Apply conditional formatting

You can apply conditional formatting to tables or charts to highlight values in the data. This makes values above, below, or within a particular threshold stand out.

Understand conditional formatting

Many companies create pinboards with key metrics they want to track in daily or weekly staff meetings. Using conditional formatting, they can see at a glance how they are performing relative to these metrics.

You can add visual cues for KPIs (Key Performance Indicators) or threshold metrics to charts and tables, to easily show where you are falling short or exceeding targets. These visual cues are called conditional formatting, which applies color formatting to your search result. For tables, you can add conditional formatting to set the background color of cells in a table based on the values they contain. For charts, you can add conditional formatting to show the threshold(s) you defined, and the data that falls within them will be shown using the same color.

Apply conditional formatting to a table

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

You can only apply conditional formatting to numbers and strings. For example, you can apply conditional formatting to a month of year column, with values such as January, but not to a date column where dates are in the format 1 Jan 2021.

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 More menu icon more options menu icon.

    conditional formatting table 1
  2. Select Conditional Formatting.

  3. Click + ADD FORMATTING in the Conditional Formatting window.

  4. Define the sets of values and the color to use for each set.

    conditional formatting table 3
  5. Click Done after defining all of your conditional formatting sets.

    conditional formatting table 4
If you change to a chart type, you must apply conditional formatting again. Conditional formatting is tied to the specific visualization.

Apply conditional formatting to a chart

You can use conditional formatting to show charts with a target value or range drawn as a line in the chart, and the legend colors determined by where values fall relative to the target.

To apply conditional formatting to a chart:

  1. Click the axis label of your chart. Select Conditional Formatting.

  2. Click + ADD FORMATTING in the Conditional Formatting window.

  3. Define the ranges of values and the color to use for each range you want to track. To add another range, click the + icon and repeat.

    set conditional formatting
  4. Click Done after defining all of your conditional formatting ranges.

    conditional formatting chart
If you change the chart type, you must apply conditional formatting again. It is tied to the specific visualization.

Limitations

The following chart types do NOT support conditional formatting:

  • Funnel

  • Geo area

  • Geo bubble

  • Geo heatmap

  • Heatmap

  • Pie

  • Radar

  • Sankey

  • Treemap



Was this page helpful?