The ribbon command Home | group Format | Conditional formatting 
allows you to apply conditional formatting to cells. Conditional formatting will only be applied when a certain condition is met. This way you can automatically change the appearance of a cell, for example, a cell is displayed in red color whenever its content is greater than 1000.
On the next pages you will find out everything you need to know about it. The following topics are covered:
▪Creating new formatting rules
| To apply conditional formatting to cells, you select those cells and create a so-called formatting rule for them. Example: "If the cell content is greater than 1000, display it in red color." |
| You can create as many formatting rules for a cell (or cell range) as you like. For example, you can add a second rule that formats the cell in boldface if it contains a value below zero etc. etc. |
▪Types of conditional formatting
| This section details the different types of formatting rules available. |
| The Manage rules command gives you access to a dialog box where you can manage all conditional formatting in a document. For example, you can edit conditional formatting rules, delete rules, etc. |
▪Removing conditional formatting
| The last section covers the removal of conditional formatting. |