Conditional Formatting

• Formatting of cells based on the values

• You define condition which, when true, applies formatting to the cells.

• Format menu, Conditional Formatting:

  • Add: maximum of three conditions per cell

  • A condition is based on either on the value, or a formula

  • Delete one or more conditions

• Tools, Options, View tab, Zero values - controls whether empty cells contain a zero or not.