You can use the ribbon command Home | group Format | Conditional formatting 
to apply conditional formatting to cells. This will only be applied if a certain condition is met. Thus, for example, you can specify that a cell should be colored red whenever it contains a value greater than 1000.
You will find out everything you need to know about it on the following pages. The following topics are covered:
▪Creating new formatting rules
| To apply conditional formatting to cells, you select the relevant cells and create a formatting rule for them – for example: "If the cell content is greater than 1000, display the cell in red." |
| You can apply any number of formatting rules to a cell – for example, you can create a second rule that formats the cell in boldface if it contains a value below zero, etc. |
▪Types of conditional formatting
| This section deals with the different types of conditional formatting. |
| You can use the command Manage rules to centrally manage all conditional formatting in the document, including editing and deleting it. |
▪Removing conditional formatting
| The last section covers the removal of conditional formatting. |