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
Start the query or the ad-hoc analysis . Click Output if the table is hidden. Activate the Data tab bar. Select the area of the spreadsheet for which you want to define a conditional formatting. Click Conditional formatting . Click the type of conditional formatting. The respective dialog for defining the conditional formatting opens. 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
Which conditional formattings exist?