Create conditional formatting for cells

You can specify that cells should be displayed differently under certain circumstances. You can for example, change the background color of a cell when the value of the cell is within a certain range of numbers.

Prerequisite

A table view is created for the query or the ad-hoc analysis.

Procedure

  1. Start the query or the ad-hoc analysis.
  2. Click Output Output if the table is hidden.
  3. Activate the Data tab bar.
  4. Select the area of the spreadsheet for which you want to define a conditional formatting.
  5. Click Conditional formatting Conditional formatting.
  6. Click the type of conditional formatting. The respective dialog for defining the conditional formatting opens.
  7. Specify the relevant settings and click OK.

If the condition is met in the selected area of the spreadsheet, the set formatting is used.

See also

Conditional formattings