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