Use conditional formatting to highlight values above, below, or within a threshold in a table or chart.You can apply conditional formatting to tables or charts to highlight values in the data — making values above, below, or within a particular threshold stand out.
Understand conditional formatting
Many companies build Dashboards with key metrics they track in daily or weekly staff meetings. Conditional formatting lets them see at a glance how they’re performing relative to those metrics, using visual cues — color formatting applied to the search result — for KPIs or threshold metrics. For tables, conditional formatting sets a cell’s background color based on the value it contains. For charts, it shows the threshold(s) you defined, with the data that falls within them shown in the same color.Apply conditional formatting to a table
- In the column header of the column you want to format, click the More menu icon.
- Select Conditional Formatting.
- Click + ADD FORMATTING in the Conditional Formatting window.
- Define the sets of values and the color to use for each set.
- Click Done after defining all your conditional formatting sets.
NoteIf you change to a chart type, you must reapply conditional formatting — it’s tied to the specific visualization.
Apply conditional formatting to a chart
- Click the axis label of your chart. Select Conditional Formatting.
- Click + ADD FORMATTING in the Conditional Formatting window.
- Define the ranges of values and the color to use for each range you want to track. Click + to add another range and repeat.
- Click Done after defining all your conditional formatting ranges.
NoteIf you change the chart type, you must reapply conditional formatting — it’s tied to the specific visualization.