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
If the condition is met in the selected area of the spreadsheet, the set formatting is used.
See also
Conditional formattings