Conditional formatting is a way of applying a format only to cells that satisfy a particular condition. The user selects the appropriate range of cells, the condition and the format This allows you to determine how the cells will be formatted, according to conditions set by you. There are two essential stages: selecting the relevant cells by setting a condition that identifies them; applying a format to the cells selected by the condition.
First, select the range to which you would like the conditional format applied.
Select Conditional from the Format menu to open the Conditional Formatting box.
Choose which criterion to apply to the Cell Value: is between, is not between, is equal to, is not equal to, is greater than, and so on.
Enter the value (or values) in the adjacent box (or boxes). One or two boxes will be displayed depending on the criterion chosen e.g. is greater than requires 1 box; is between requires 2 boxes.
Click on the Format button to display another box, in which there are options for these formats: Number, Alignment, Font, Border, Color, Cell Attributes.
Once you have selected your formats, click on OK to close this box.
Finally click on the Add Condition button to save the new condition and the associated format to the Conditions box below. Note that you can create several conditions and formats and add them to this box. All of these will be applied to the selected cells at the same time.
At this point you can either apply the condition/s directly (click OK) or choose to store the condition/s for future use by creating a Style:
Click on the More button to expand the box.
Click on Add Style: Enter a name for the style in the displayed name box and then click on OK.
The style name is added to the Conditional Styles box.
Add and store as many styles as you like.
In future you can enter Conditional Formatting box and apply the required style and its associated conditions without having to start from scratch.
When you click on OK the format or style will be applied to the selected range according to the condition/s set by you e.g. you may decide that all numbers between 100 and 200 in the range A1...C100 should be formatted red.
To clear a conditional format, select the appropriate cells, right-click and select Clear/Format.