Create conditional formatting

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

  1. Open a spreadsheet.
  2. Activate the Contents tab bar.
  3. Select the area of the spreadsheet for which you want to define a conditional formatting.
  4. Click Conditional formatting Conditional formatting.
  5. Click the type of conditional formatting. The respective dialog for defining the conditional formatting opens.
  6. 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?