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
Open a spreadsheet.
Activate the Contents 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.