Conditional formatting

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.

  1. Click on the More button to expand the box.

  2. Click on Add Style: Enter a name for the style in the displayed name box and then click on OK.

  3. The style name is added to the Conditional Styles box.

  4. Add and store as many styles as you like.

  5. In future you can enter Conditional Formatting box and apply the required style and its associated conditions without having to start from scratch.

To clear a conditional format, select the appropriate cells, right-click and select Clear/Format.