COLOUR FORMATTING

The below information can be found on page 21 of the Intermediate Course Manual. This can be downloaded from the resources page if you don't have a copy.

Applying Conditional Formatting
To use conditional formatting:
Select a range of data that you want to apply the formatting to.
On the Home ribbon, Styles group, click the Conditional Formatting button.
This will display a menu of conditional formatting options. From this menu, you can choose:
Select the option you wish to use to apply formatting

Highlight Cells Rules This will highlight cells that are greater than, less than, between or equal to values that you can specify.

You will need to apply each rule separately to each cell, so ensure only one cell is selected.


NOTE:
If you have been applying lots of conditional formatting and it still not working, ensure you have deleted the old formatting you applied to the cells as this could be affecting the results.

To remove conditional formatting, highlight the cells, On the Home ribbon, Styles group, click the Conditional Formatting button. Select Clear Rules